User`s guide

uDayOfYear
142 Sybase IQ ETL 4.1
uDayOfYear
Description Returns the number of days since the beginning of the year.
Syntax string uDayOfYear([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples To get the day number out of a timestamp:
uDayOfYear("now") // returns how many day have already
passed this year
uDayOfYear("1969-03-13 10:22:23.231") // returns "72"
uHour
Description Returns the hour of the date specified.
Note Please refer to the “Working with Dates and Times” section for detailed
information about the possible modifier arguments.
Syntax string uHour([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples Get the hour from a date.
uHour("now") // returns current hour
uHour("1969-03-13 10:22:23.231") // returns "10"
uQuarter
Description Returns of the year in which a date occurs.
Syntax string uQuarter([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples To get the hour from a date: