Neoview SQL Reference Manual (R2.4 SP2)

CONVERTTOHEX Function...............................................................................................................354
Considerations for CONVERTTOHEX..........................................................................................354
Examples of CONVERTTOHEX....................................................................................................354
CONVERTTIMESTAMP Function......................................................................................................356
Considerations for CONVERTTIMESTAMP.................................................................................356
Examples of CONVERTTIMESTAMP...........................................................................................356
COS Function......................................................................................................................................357
Example of COS.............................................................................................................................357
COSH Function...................................................................................................................................358
Example of COSH..........................................................................................................................358
COUNT Function................................................................................................................................359
Considerations for COUNT...........................................................................................................359
Examples of COUNT.....................................................................................................................359
CURRENT Function............................................................................................................................361
Example of CURRENT..................................................................................................................361
CURRENT_DATE Function................................................................................................................362
Examples of CURRENT_DATE.....................................................................................................362
CURRENT_ROLE Function................................................................................................................363
Considerations for CURRENT_ROLE...........................................................................................363
Example of CURRENT_ROLE.......................................................................................................363
CURRENT_TIME Function.................................................................................................................364
Example of CURRENT_TIME.......................................................................................................364
CURRENT_TIMESTAMP Function....................................................................................................365
Example of CURRENT_TIMESTAMP...........................................................................................365
CURRENT_USER Function................................................................................................................366
Considerations for CURRENT_USER...........................................................................................366
Example of CURRENT_USER.......................................................................................................366
DATE_ADD Function.........................................................................................................................367
Examples of DATE_ADD...............................................................................................................367
DATE_SUB Function...........................................................................................................................368
Examples of DATE_SUB................................................................................................................368
DATEADD Function...........................................................................................................................369
Examples of DATEADD................................................................................................................369
DATEDIFF Function............................................................................................................................370
Examples of DATEDIFF.................................................................................................................370
DATEFORMAT Function....................................................................................................................371
Considerations for DATEFORMAT...............................................................................................371
Examples of DATEFORMAT.........................................................................................................371
DATE_PART Function (of an Interval)...............................................................................................372
Examples of DATE_PART..............................................................................................................372
DATE_PART Function (of a Timestamp)............................................................................................373
Examples of DATE_PART..............................................................................................................373
DATE_TRUNC Function.....................................................................................................................374
Examples of DATE_TRUNC..........................................................................................................374
DAY Function......................................................................................................................................375
Example of DAY.............................................................................................................................375
DAYNAME Function..........................................................................................................................376
Considerations for DAYNAME.....................................................................................................376
Example of DAYNAME.................................................................................................................376
DAYOFMONTH Function..................................................................................................................377
Examples of DAYOFMONTH.......................................................................................................377
DAYOFWEEK Function......................................................................................................................378
Example of DAYOFWEEK.............................................................................................................378
DAYOFYEAR Function.......................................................................................................................379
Example of DAYOFYEAR..............................................................................................................379
Table of Contents 11