User`s guide

uDate
140 Sybase IQ ETL 4.1
•The localtime() C function normally only works for years between 1970
and 2037. For dates outside this range, you can attempt to map the year
into an equivalent year within this range, do the calculation, then map the
year back.
• Date computations do not give correct results for dates before Julian day
number 0 (-4713-11-24 12:00:00).
• All internal computations assume the Gregorian calendar system. When
you use the “julian” modifier, it does not convert the date into a real Julian
calendar date; instead, it shifts the Gregorian calendar date to align it with
the Julian calendar. This means that the “julian” modifier will not work
right for dates that exist in the Julian calendar but which do not exist in the
Gregorian calendar, for example, 1900-02-29.
uDate
Description Returns the year, month, and day from a date in the format YYYY-MM-DD.
Note Refer to the “Working with Dates and Times” section for detailed
information about the possible modifier arguments.
Syntax string uDate([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples To get the date part out of a timestamp:
uDate("now") // returns current date in the form "YYYY-
MM-DD".
uDate("now", "start of year", "9 months", "weekday 2")
//returns the date of the first Tuesday in October of
this year.