Extended Systems OneBridge 4.1 Guía de usuario descargar pdf (Pagina 158)

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"

1 2 ... 153 154 155 156 157 158 159 160 161 162 163 ... 221 222

Sin comentarios

Extended Systems OneBridge 4.1 Guía de usuario Pagina 158