SQL Dialects Reference/Data structure definition/Data types/Date and time types

Date and time types

This page includes comparison tables which can be big and complex.

While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.

SQL version	Feature	Standard	DB2	Firebird	Ingres	Linter	MSSQL	MySQL	MonetDB	Oracle	PostgreSQL	SQLite	Virtuoso
SQL-92	Date only	DATE	DATE	DATE	DATE ANSIDATE INGRESDATE	DATE, DATETIME	date	DATE	DATE	DATE	DATE	DATE	DATE
SQL-92	Time only	TIME	TIME	TIME	TIME [WITHOUT TIME ZONE]	DATE DATETIME	time	TIME	TIME		TIME [WITHOUT TIME ZONE]	TIME	TIME
?	Time with time zone	?	?	?	TIME WITH TIME ZONE	?	N/A	N/A	TIME WITH TIME ZONE	?	TIME WITH TIME ZONE	?	N/A
SQL-92	Date and time without time zone	TIMESTAMP	TIMESTAMP	TIMESTAMP	DATE TIMESTAMP ANSIDATE INGRESDATE	DATE DATETIME	datetime2 datetime smalldatetime	DATETIME TIMESTAMP	TIMESTAMP TIMESTAMP WITH TIME ZONE	DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMP [WITHOUT TIME ZONE]	DATETIME TIMESTAMP	DATETIME TIMESTAMP
?	Date and time with time zone	?	?	?	?	?	datetimeoffset	N/A	TIMESTAMP TIMESTAMP WITH TIME ZONE	?	TIMESTAMP WITH TIME ZONE	?	N/A
?	Time interval	?	?	?	INTERVAL DAY TO SECOND(n) INTERVAL YEAR TO MONTH	?	N/A	?	INTERVAL	INTERVAL DAY TO SECOND INTERVAL YEAR TO MONTH	INTERVAL	?	?