DATETIME

Description

The DATETIME data type is used to represent a data value in which the data (year, month, date) and time (hour, minute, second) are combined. The range of representable value is between 0001-01-01 00:00:00.000 and 9999-12-31 23:59:59.999 (GMT).

The input format of TIMESTAMP is as follows:

'hh:mi [:ss[.msec]] [am|pm] mm/dd [/yyyy]'

'hh:mi [:ss[.msec]] [am|pm] [yyyy-]mm-dd'

'mm/dd[/yyyy] hh:mi[:ss[.ff]] [am|pm]'

'[yyyy-]mm-dd hh:mi[:ss[.ff]] [am|pm]'

Remark
Example

DATETIME '10/31' is outputted as '12:00:00.000 AM 10/31/2011' (if the value for year/time is omitted, a default value is outputted).

DATETIME '10/31/2008' is outputted as '12:00:00.000 AM 10/31/2008'.

DATETIME '13:15:45 10/31/2008' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '01:15:45 PM 2008-10-31' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '13:15:45 2008-10-31' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '10/31/2008 01:15:45 PM' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '10/31/2008 13:15:45' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '2008-10-31 01:15:45 PM' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '2008-10-31 13:15:45' is outputted as '01:15:45.000 PM 10/31/2008'.

DATETIME '2099-10-31 01:15:45 PM' is outputted as '01:15:45.000 PM 10/31/2099'.