Neoview SQL Reference Manual (R2.3)

Examples of DATE_TRUNC..........................................................................................................335
DAY Function......................................................................................................................................336
Example of DAY.............................................................................................................................336
DAYNAME Function..........................................................................................................................337
Example of DAYNAME.................................................................................................................337
DAYOFMONTH Function..................................................................................................................338
Examples of DAYOFMONTH.......................................................................................................338
DAYOFWEEK Function......................................................................................................................339
Example of DAYOFWEEK.............................................................................................................339
DAYOFYEAR Function.......................................................................................................................340
Example of DAYOFYEAR..............................................................................................................340
DECODE Function..............................................................................................................................341
Considerations for DECODE.........................................................................................................341
Examples of DECODE...................................................................................................................342
DEGREES Function.............................................................................................................................344
Examples of DEGREES..................................................................................................................344
DIFF1 Function....................................................................................................................................345
Considerations for DIFF1...............................................................................................................345
Equivalent Result......................................................................................................................345
Datetime Arguments................................................................................................................345
Examples of DIFF1.........................................................................................................................345
DIFF2 Function....................................................................................................................................347
Considerations for DIFF2...............................................................................................................347
Equivalent Result......................................................................................................................347
Datetime Arguments................................................................................................................347
Examples of DIFF2.........................................................................................................................347
EXP Function.......................................................................................................................................349
Examples of EXP............................................................................................................................349
EXPLAIN Function.............................................................................................................................350
Considerations for EXPLAIN Function.........................................................................................350
Using a Statement Pattern........................................................................................................350
Result of the EXPLAIN Function.............................................................................................350
Examples of EXPLAIN Function...................................................................................................352
EXTRACT Function.............................................................................................................................353
Examples of EXTRACT..................................................................................................................353
FLOOR Function.................................................................................................................................354
Examples of FLOOR......................................................................................................................354
HOUR Function..................................................................................................................................355
Example of HOUR.........................................................................................................................355
INSERT Function................................................................................................................................356
Examples of INSERT......................................................................................................................356
ISNULL Function................................................................................................................................357
Examples of ISNULL.....................................................................................................................357
JULIANTIMESTAMP Function...........................................................................................................358
Examples of JULIANTIMESTAMP................................................................................................358
LASTNOTNULL Function..................................................................................................................358
Example of LASTNOTNULL.........................................................................................................358
LCASE Function..................................................................................................................................360
Example of LCASE........................................................................................................................360
LEFT Function.....................................................................................................................................361
Examples of LEFT..........................................................................................................................361
LOCATE Function...............................................................................................................................362
Considerations for LOCATE..........................................................................................................362
Result of LOCATE....................................................................................................................362
Using UCASE...........................................................................................................................362
Table of Contents 15