Date and time types are used when you wish to store a date, time, or timestamp (date and time) value.


Literals

---

Date and time literals use the IS0 8601 standard which dictates the following formats:


Literal Examples

---

-- This example specifies a date literal

SELECT * FROM Orders
WHERE OrderDate BETWEEN DATE '2006-01-01' AND DATE '2006-01-31'

-- This example specifies a TIME literal
-- using 24-hour format

SELECT * FROM TimeClockEntries
WHERE PunchInTime > TIME '16:00'

-- This example specifies a TIME literal
-- using 12-hour format

SELECT * FROM TimeClockEntries
WHERE PunchInTime > TIME '4:00 PM'

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: