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

From Wikibooks, the open-content textbooks collection

Jump to: navigation, search

[edit] 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.

Feature DB2 Firebird Ingres MSSQL MySQL Oracle PostgreSQL SQLite Virtuoso Linter
Date only DATE DATE DATE DATETIME DATE DATE DATE DATE DATE DATE,
DATETIME
Time only TIME TIME TIME TIME TIME TIME TIME DATE,
DATETIME
Date and time TIMESTAMP TIMESTAMP DATE,
TIMESTAMP,
ANSIDATE,
INGRESDATE		 DATETIME DATETIME
TIMESTAMP		 DATE,
TIMESTAMP,
TIMESTAMP WITH TIME ZONE,
TIMESTAMP WITH LOCAL TIME ZONE		 TIMESTAMP,
TIMESTAMP WITH TIME ZONE		 DATETIME
TIMESTAMP		 DATETIME
TIMESTAMP		 DATE,
DATETIME
Time interval INTERVAL DAY TO SECOND(n),
INTERVAL YEAR TO MONTH		 INTERVAL DAY TO SECOND,
INTERVAL YEAR TO MONTH		 INTERVAL
Retrieved from "http://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Data_types/Date_and_time_types"