Neoview SQL Reference Manual (R2.4)

Considerations for COUNT...........................................................................................................350
Examples of COUNT.....................................................................................................................350
CURRENT Function............................................................................................................................352
Example of CURRENT..................................................................................................................352
CURRENT_DATE Function................................................................................................................353
Examples of CURRENT_DATE.....................................................................................................353
CURRENT_ROLE Function................................................................................................................354
Considerations for CURRENT_ROLE...........................................................................................354
Example of CURRENT_ROLE.......................................................................................................354
CURRENT_TIME Function.................................................................................................................355
Example of CURRENT_TIME.......................................................................................................355
CURRENT_TIMESTAMP Function....................................................................................................356
Example of CURRENT_TIMESTAMP...........................................................................................356
CURRENT_USER Function................................................................................................................357
Considerations for CURRENT_USER...........................................................................................357
Example of CURRENT_USER.......................................................................................................357
DATE_ADD Function.........................................................................................................................358
Examples of DATE_ADD...............................................................................................................358
DATE_SUB Function...........................................................................................................................359
Examples of DATE_SUB................................................................................................................359
DATEADD Function...........................................................................................................................360
Examples of DATEADD................................................................................................................360
DATEDIFF Function............................................................................................................................361
Examples of DATEDIFF.................................................................................................................361
DATEFORMAT Function....................................................................................................................362
Considerations for DATEFORMAT...............................................................................................362
Examples of DATEFORMAT.........................................................................................................362
DATE_PART Function (of an Interval)...............................................................................................363
Examples of DATE_PART..............................................................................................................363
DATE_PART Function (of a Timestamp)............................................................................................364
Examples of DATE_PART..............................................................................................................364
DATE_TRUNC Function.....................................................................................................................365
Examples of DATE_TRUNC..........................................................................................................365
DAY Function......................................................................................................................................366
Example of DAY.............................................................................................................................366
DAYNAME Function..........................................................................................................................367
Considerations for DAYNAME.....................................................................................................367
Example of DAYNAME.................................................................................................................367
DAYOFMONTH Function..................................................................................................................368
Examples of DAYOFMONTH.......................................................................................................368
DAYOFWEEK Function......................................................................................................................369
Example of DAYOFWEEK.............................................................................................................369
DAYOFYEAR Function.......................................................................................................................370
Example of DAYOFYEAR..............................................................................................................370
DECODE Function..............................................................................................................................371
Considerations for DECODE.........................................................................................................371
Examples of DECODE...................................................................................................................372
DEGREES Function.............................................................................................................................374
Examples of DEGREES..................................................................................................................374
DIFF1 Function....................................................................................................................................375
Considerations for DIFF1...............................................................................................................375
Examples of DIFF1.........................................................................................................................375
DIFF2 Function....................................................................................................................................377
Considerations for DIFF2...............................................................................................................377
Examples of DIFF2.........................................................................................................................377
Table of Contents 11