paperlined.org
apps > sql

document updated 4 months ago, on Sep 30, 2025

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)