SAND CDBMS Tools Reference Guide
NDL++ Functions: Syntax and Examples

Return to String Function Index

 

String Function Syntax and Examples

DATE( )

The DATE() function returns the current date in the specified format. Consult the Data Types section of the SAND CDBMS SQL Reference Guide for information about the date formats acceptable for insertion into DATE-type columns.

Syntax:

DATE( ['format'] )  

where:

Format can be any combination of the characters d (day), m (month), and y (year). Any ASCII characters other than these can be used as separators. If omitted, the date is returned in the default format (dd/mm/yyyy).

Example:

schema1.table1
{
col1 DATE('mm/DD/yyyy')
col2 DATE()
col3 DATE('dd.mm.yyyy')
}

Results:

For March 31, 2002:

schema1.table1.col1	03/31/2002
schema1.table1.col2	31/03/2002
schema1.table1.col3	31.03.2002

 

Return to String Function Index