WeekdayFromDate() Function in Transformer Stage in DataStage

Returns the day number of the week from the given date. Origin_day optionally specifies the day regarded as the first in the week and is Sunday by default.

    Input: date, [origin_day]
    Output: day (int8)
    Examples. If mylink.mydate contains the date 2008-08-19, then the two following functions are equivalent, and return the value 2:

    WeekdayFromDate(“2008-08-19”)
    WeekdayFromDate(mylink.mydate)

You can watch video tutorial of this function here:

Comments

comments

Leave a Reply