dates in SQL

standards

SQL has been standardized by both ANSI and the ISO organization. Some names for standardized SQL are 'SQL-92' and 'SQL:1999'.

There are also standards for time strings, such as ISO 8601.

standards manuals

• SQL-92

ways to express dates/times and durations in standardized SQL

• CURRENT_TIME
• DATE '1992-02-28' (year first!)
• TIME '12:30:59'
• TIMESTAMP '1992-02-28 12:30:59'

(for more, Ctrl-F for "<timestamp literal>" here)