Basic elements of SQL : Literals : Date/time literals : Extended syntax

Extended syntax

OpenAccess SDK supports extended syntax for specifying the date-time string literals. The month can be specified using the long or short month name (minimum three characters), or in digits. The separator between fields is optional and can be one of the following characters:

- / :

Examples in extended syntax

Date Literal:	'Jan 2 1999'
	'2 Jan 1999'
	'1999/01/02'
	'1999-01-02'
	'1999-1-2'
Time Literal:	'8:30:03'
	'8:30:03 A.M'

Extended syntax in BNF notation

In BNF notation, the syntax is as follows:

<date-time-literal> ::=

< date-str>

| <time-str>

| <date-str> <time-str>

| <time-str> <date-str>

| CURRENT

<date-str> ::=

MONTH opt_SEP DIGITS opt_SEP DIGITS

| DIGITS opt_SEP MONTH opt_SEP DIGITS

| MONTH opt_SEP DIGITS

| DIGITS opt_SEP MONTH

| DIGITS date_SEP DIGITS date_SEP DIGITS

<time-str> ::=

DIGITS time_SEP DIGITS time_SEP DIGITS ms_SEP MICROSEC_DIGITS opt_AMPM

DIGITS time_SEP DIGITS time_SEP DIGITS opt_AMPM

<opt_AMPM> ::=

| A.M

| AM

| P.M

| PM

<date_SEP> ::= DASH_SEP

| SLASH_SEP

<time_SEP>::= COLON_SEP

<ms_SEP>::= SEP

| DOT_SEP

DIGITS ::= Number containing the digits 0 to 9

   SEP ::= characters other than DOT_SEP, DASH_SEP, SLASH_SEP, and COLON_SEP are considered as separators
  

MONTH ::= Jan[uary]

| Feb[ruary]

| Mar[ch]

| Apr[il]

| May

...

<opt_SEP> ::=

| SEP