Neoview SQL Reference Manual (R2.4)

EXP Function.......................................................................................................................................379
Examples of EXP............................................................................................................................379
EXPLAIN Function.............................................................................................................................380
Considerations for EXPLAIN Function.........................................................................................380
Examples of EXPLAIN Function...................................................................................................382
EXTRACT Function.............................................................................................................................383
Examples of EXTRACT..................................................................................................................383
FLOOR Function.................................................................................................................................384
Examples of FLOOR......................................................................................................................384
HOUR Function..................................................................................................................................385
Example of HOUR.........................................................................................................................385
INSERT Function................................................................................................................................386
Examples of INSERT......................................................................................................................386
ISNULL Function................................................................................................................................387
Examples of ISNULL.....................................................................................................................387
JULIANTIMESTAMP Function...........................................................................................................388
Considerations for JULIANTIMESTAMP.....................................................................................388
Examples of JULIANTIMESTAMP................................................................................................388
LASTNOTNULL Function..................................................................................................................389
Example of LASTNOTNULL.........................................................................................................389
LCASE Function..................................................................................................................................390
Considerations for LCASE.............................................................................................................390
Example of LCASE........................................................................................................................390
LEFT Function.....................................................................................................................................391
Examples of LEFT..........................................................................................................................391
LOCATE Function...............................................................................................................................392
Considerations for LOCATE..........................................................................................................392
Examples of LOCATE....................................................................................................................392
LOG Function......................................................................................................................................393
Example of LOG............................................................................................................................393
LOG10 Function..................................................................................................................................394
Example of LOG10.........................................................................................................................394
LOWER Function................................................................................................................................395
Considerations for LOWER...........................................................................................................395
Example of LOWER.......................................................................................................................399
LPAD Function....................................................................................................................................400
Examples of LPAD.........................................................................................................................400
LTRIM Function..................................................................................................................................401
Considerations for LTRIM.............................................................................................................401
Example of LTRIM.........................................................................................................................401
MAX/MAXIMUM Function................................................................................................................402
Considerations for MAX................................................................................................................402
Example of MAX............................................................................................................................402
MIN Function......................................................................................................................................403
Considerations for MIN.................................................................................................................403
Example of MIN.............................................................................................................................403
MINUTE Function...............................................................................................................................404
Example of MINUTE.....................................................................................................................404
MOD Function....................................................................................................................................405
Example of MOD...........................................................................................................................405
MONTH Function...............................................................................................................................406
Example of MONTH......................................................................................................................406
MONTHNAME Function...................................................................................................................407
Considerations for MONTHNAME..............................................................................................407
Example of MONTHNAME..........................................................................................................407
12 Table of Contents