Date Functions

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Date Functions

Post by ray.wurlod »

This Pickwiki posting has a number of useful date functions using Iconv()/Oconv().
    GetDateFormat - return: true if International format (dd/mm/yy) is set.

    GetElapsedPeriod - return: elapsed years @am months @am days

    GetElapsedTime - return: difference in seconds

    GetElapsedTime.toString - return: oconv'd time (hh:mm:ss)

    GetEpochTime - return: epoch time - seconds from 1970-01-01 UTC

    GetISODateTime - return: ISO Date Time string yyyy-mm-ddThh:mm:ssZ

    GetISOWeekOfYear - return: ISO8601 week of year

    GetRFCDateTime - return: RFC 1123 Date Time string: Sun, 06 Nov 1994
    08:49:37 GMT

    GetNumberSuffix - return: numeric ordinal suffix ('st,nd,rd,th')

    GetTimeZoneString - return: users current TZ string

    ParseEpochTime - return: date:@am:time [local at the time zone]

    ParseEpochTime.toString - return: iso date time

    ParseISODateTime - return: epoch time - seconds from 1970-01-01 UTC

    ParseISODateTime.local - return: (user local) date:@am:time

    ParseRFCDateTime - return: Epoch time - seconds from 1970-01-01 UTC

    ParseRFCDateTime.local - return: (user local) date:@am:time

    SetDateFormat - Set the date format ON to International (dd/mm/yy)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply