dates and times 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'.

For date string standards, see ISO-8601 (examples) or RFC-3339.

standards manuals

• SQL-92

ways to express dates/times and durations in standardized SQL

• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP (date + time)
• DATE '1992-02-28' (it must be in year-month-day order)
• TIME '12:30:59'
• TIMESTAMP '1992-02-28 12:30:59'

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