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 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: