YeardayFromDate() Function in Transformer Stage in DataStage

Returns the day number in the year from the given date.

Input: date
Output: day (int16)
Examples. If mylink.mydate contains the date 2008-08-20, then two following functions are equivalent, and return the value 233.

YeardayFromDate(“2008-08-20”)
YeardayFromDate(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: