User`s guide

uJuliandate
144 Sybase IQ ETL 4.1
uJuliandate
Description Returns the number of days since noon in Greenwich on November 24, 4714
B.C. in the format DDDD.DDDD. For date and time calculation, the
juliandate
function is the best choice.
Syntax string uJuliandate([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples To convert a date into a numerical value for calculation.
uJuliandate(‘now’) // returns current date in the form
"DDDD.DDDD"
To compute the number of seconds between two dates:
uJuliandate(‘now’)*86400 - julianday('2004-01-01
02:34:56')*86400
To compute the number of days since the Battle of Hastings:
uJuliandate(‘now’) - uJuliandate('1066-10-
14','gregorian')
To compute the date and time given a UNIX timestamp 1092941466, and
compensate for your local time zone:
uJuliandate(1092941466, 'unixepoch', 'localtime');
uMinute
Description Returns the minute of the date specified.
Syntax string uMinute([modifiers])
Parameters
string modifiers (optional)
String specifying a date or date calculation. The default is the
now modifier.
Examples Get the minute from a date
uMinute("now") // returns current minute
uMinute("1969-03-13 10:22:23.231") // returns "22"