Navigation:  NexusDB Guide > SQL Reference > SQL Language Elements > Literals >

DateTime Literals

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

DateTime Literals

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > SQL Language Elements > Literals

Syntax

 

<datetime literal> ::=

<date literal> ::= DATE <date string>

 

<time literal> ::= TIME <time string>

 

<timestamp literal> ::= TIMESTAMP <timestamp string>

 

<date string> ::= <quote> year-month-day <quote>

 

<time string> ::= <quote> hour:minute:second [ . [ millisecond ] ] <quote>

 

<timestamp string> ::= <quote> year-month-day hour:minute:second [ . [ millisecond ] ] <quote>

 

 

Examples

 

 

Data Type

 

 

Literal Examples

 

DATE

DATE '2004-09-25'

TIME

TIME '14:28:36'

TIMESTAMP

TIMESTAMP '2004-09-25 14:28:36'

 


Conformance

 

SQL:2003 standard

-

Core SQL

 

© Nexus Database Systems Pty Ltd.

nexus_logo