Neoview SQL Reference Manual (R2.4 SP2)

DECODE Function..............................................................................................................................380
Considerations for DECODE.........................................................................................................380
Examples of DECODE...................................................................................................................381
DEGREES Function.............................................................................................................................383
Examples of DEGREES..................................................................................................................383
DIFF1 Function....................................................................................................................................384
Considerations for DIFF1...............................................................................................................384
Examples of DIFF1.........................................................................................................................384
DIFF2 Function....................................................................................................................................386
Considerations for DIFF2...............................................................................................................386
Examples of DIFF2.........................................................................................................................386
EXP Function.......................................................................................................................................388
Examples of EXP............................................................................................................................388
EXPLAIN Function.............................................................................................................................389
Considerations for EXPLAIN Function.........................................................................................389
Examples of EXPLAIN Function...................................................................................................391
EXTRACT Function.............................................................................................................................392
Examples of EXTRACT..................................................................................................................392
FLOOR Function.................................................................................................................................393
Examples of FLOOR......................................................................................................................393
HOUR Function..................................................................................................................................394
Example of HOUR.........................................................................................................................394
INSERT Function................................................................................................................................395
Examples of INSERT......................................................................................................................395
ISNULL Function................................................................................................................................396
Examples of ISNULL.....................................................................................................................396
JULIANTIMESTAMP Function...........................................................................................................397
Considerations for JULIANTIMESTAMP.....................................................................................397
Examples of JULIANTIMESTAMP................................................................................................397
LASTNOTNULL Function..................................................................................................................398
Example of LASTNOTNULL.........................................................................................................398
LCASE Function..................................................................................................................................399
Considerations for LCASE.............................................................................................................399
Example of LCASE........................................................................................................................399
LEFT Function.....................................................................................................................................400
Examples of LEFT..........................................................................................................................400
LOCATE Function...............................................................................................................................401
Considerations for LOCATE..........................................................................................................401
Examples of LOCATE....................................................................................................................401
LOG Function......................................................................................................................................402
Example of LOG............................................................................................................................402
LOG10 Function..................................................................................................................................403
Example of LOG10.........................................................................................................................403
LOWER Function................................................................................................................................404
Considerations for LOWER...........................................................................................................404
Example of LOWER.......................................................................................................................404
LPAD Function....................................................................................................................................405
Examples of LPAD.........................................................................................................................405
LTRIM Function..................................................................................................................................406
Considerations for LTRIM.............................................................................................................406
Example of LTRIM.........................................................................................................................406
MAX/MAXIMUM Function................................................................................................................407
Considerations for MAX/MAXIMUM...........................................................................................407
Example of MAX/MAXIMUM.......................................................................................................407
MIN Function......................................................................................................................................408
12 Table of Contents