Neoview SQL Reference Manual (R2.3)

CHAR_LENGTH Function.................................................................................................................313
Considerations for CHAR_LENGTH............................................................................................313
CHAR and VARCHAR Operands............................................................................................313
Examples of CHAR_LENGTH......................................................................................................313
COALESCE Function..........................................................................................................................314
Example of COALESCE.................................................................................................................314
CODE_VALUE Function.....................................................................................................................315
Example of CODE_VALUE Function............................................................................................315
CONCAT Function..............................................................................................................................316
Concatenation Operator (||).........................................................................................................316
Considerations for CONCAT.........................................................................................................316
Operands..................................................................................................................................316
SQL Parameters........................................................................................................................316
Examples of CONCAT...................................................................................................................316
CONVERTTIMESTAMP Function......................................................................................................318
Considerations for CONVERTTIMESTAMP.................................................................................318
Relationship to the JULIANTIMESTAMP Function................................................................318
Use of CONVERTTIMESTAMP...............................................................................................318
Examples of CONVERTTIMESTAMP...........................................................................................318
COS Function......................................................................................................................................319
Example of COS.............................................................................................................................319
COSH Function...................................................................................................................................320
Example of COSH..........................................................................................................................320
COUNT Function................................................................................................................................321
Considerations for COUNT...........................................................................................................321
Operands of the Expression.....................................................................................................321
Nulls.........................................................................................................................................321
Examples of COUNT.....................................................................................................................321
CURRENT Function............................................................................................................................323
Example of CURRENT..................................................................................................................323
CURRENT_DATE Function................................................................................................................324
Examples of CURRENT_DATE.....................................................................................................324
CURRENT_ROLE Function................................................................................................................325
Example of CURRENT_ROLE.......................................................................................................325
CURRENT_TIME Function.................................................................................................................326
Example of CURRENT_TIME.......................................................................................................326
CURRENT_TIMESTAMP Function....................................................................................................327
Example of CURRENT_TIMESTAMP...........................................................................................327
CURRENT_USER Function................................................................................................................328
Example of CURRENT_USER.......................................................................................................328
DATE_ADD Function.........................................................................................................................329
Examples of DATE_ADD...............................................................................................................329
DATE_SUB Function...........................................................................................................................330
Examples of DATE_SUB................................................................................................................330
DATEADD Function...........................................................................................................................330
Examples of DATEADD................................................................................................................331
DATEDIFF Function............................................................................................................................332
Examples of DATEDIFF.................................................................................................................332
DATEFORMAT Function....................................................................................................................333
Examples of DATEFORMAT.........................................................................................................333
DATE_PART Function (of an interval)................................................................................................333
Examples of DATE_PART..............................................................................................................333
DATE_PART Function (of a timestamp).............................................................................................334
Examples of DATE_PART..............................................................................................................334
DATE_TRUNC Function.....................................................................................................................335
14 Table of Contents