Neoview SQL Reference Manual (R2.2)

Operands of the Expression.....................................................................................................310
Nulls.........................................................................................................................................310
Examples of COUNT.....................................................................................................................310
CURRENT Function............................................................................................................................312
Example of CURRENT..................................................................................................................312
CURRENT_DATE Function................................................................................................................313
Examples of CURRENT_DATE.....................................................................................................313
CURRENT_ROLE Function................................................................................................................314
Example of CURRENT_ROLE.......................................................................................................314
CURRENT_TIME Function.................................................................................................................315
Example of CURRENT_TIME.......................................................................................................315
CURRENT_TIMESTAMP Function....................................................................................................316
Example of CURRENT_TIMESTAMP...........................................................................................316
CURRENT_USER Function................................................................................................................317
Example of CURRENT_USER.......................................................................................................317
DATE_ADD Function.........................................................................................................................318
Examples of DATE_ADD...............................................................................................................318
DATE_SUB Function...........................................................................................................................319
Examples of DATE_SUB................................................................................................................319
DATEADD Function...........................................................................................................................319
Examples of DATEADD................................................................................................................320
DATEDIFF Function............................................................................................................................321
Examples of DATEDIFF.................................................................................................................321
DATEFORMAT Function....................................................................................................................322
Examples of DATEFORMAT.........................................................................................................322
DATE_PART Function (of an interval)................................................................................................322
Examples of DATE_PART..............................................................................................................322
DATE_PART Function (of a timestamp).............................................................................................323
Examples of DATE_PART..............................................................................................................323
DATE_TRUNC Function.....................................................................................................................324
Examples of DATE_TRUNC..........................................................................................................324
DAY Function......................................................................................................................................325
Example of DAY.............................................................................................................................325
DAYNAME Function..........................................................................................................................326
Example of DAYNAME.................................................................................................................326
DAYOFMONTH Function..................................................................................................................327
Examples of DAYOFMONTH.......................................................................................................327
DAYOFWEEK Function......................................................................................................................328
Example of DAYOFWEEK.............................................................................................................328
DAYOFYEAR Function.......................................................................................................................329
Example of DAYOFYEAR..............................................................................................................329
DECODE Function..............................................................................................................................330
Considerations for DECODE.........................................................................................................330
Examples of DECODE...................................................................................................................331
DEGREES Function.............................................................................................................................333
Examples of DEGREES..................................................................................................................333
DIFF1 Function....................................................................................................................................334
Considerations for DIFF1...............................................................................................................334
Equivalent Result......................................................................................................................334
Datetime Arguments................................................................................................................334
Examples of DIFF1.........................................................................................................................334
DIFF2 Function....................................................................................................................................336
Considerations for DIFF2...............................................................................................................336
Equivalent Result......................................................................................................................336
Datetime Arguments................................................................................................................336
14 Table of Contents