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

Date and time types datatype3.html#datetime Date only DATE DATE DATE DATEANSIDATEINGRESDATE SQL%20Reference%20Guide/datetimedatatypes.htm#o2057 DATE 630352 date DATE datetime.html DATE DATE (includes TIME !) DATE datatype-datetime.html#DATATYPE-DATETIME-TABLE TEXTthe built-in date/time functions can use these types for storing values DATE sqlrefDATATYPES.html DATE, DATETIME Time only TIME TIME TIME TIME [WITHOUT TIME ZONE] SQL%20Reference%20Guide/datetimedatatypes.htm#o2092 677243 time TIME time.html TIME no TIME [WITHOUT TIME ZONE] datatype-datetime.html#DATATYPE-DATETIME-TABLE TEXT TIME sqlrefDATATYPES.html DATEDATETIME Time with time zone TIME WITH TIME ZONE TIME WITH TIME ZONE SQL%20Reference%20Guide/datetimedatatypes.htm#o2092 TIME WITH TIME ZONE datatype-datetime.html#DATATYPE-DATETIME-TABLE TIME WITH TIME ZONE no Date and time without time zone TIMESTAMP TIMESTAMP TIMESTAMP DATETIMESTAMPANSIDATEINGRESDATE 677335 datetime2187819 datetime182418 smalldatetime TIMESTAMP TIMESTAMP TIMESTAMP WITH TIME ZONE DATETIMESTAMP TIMESTAMP [WITHOUT TIME ZONE] datatype-datetime.html#DATATYPE-DATETIME-TABLE TEXTREALINTEGER DATETIMETIMESTAMP sqlrefDATATYPES.html DATEDATETIME Date and time with time zone TIMESTAMP WITH TIME ZONE bb630289 datetimeoffset TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE TIMESTAMP WITH TIME ZONE datatype-datetime.html#DATATYPE-DATETIME-TABLE Time interval INTERVAL DAY TO SECOND(n)INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND(n)INTERVAL YEAR TO MONTH SQL%20Reference%20Guide/datetimedatatypes.htm#o2072 INTERVAL Not available as data type, only as data values. datetime.html INTERVAL DAY[(day_precision)] TO SECOND[(fractional_second_precision)]INTERVAL YEAR [(year_precision)] TO MONTH datatype-datetime.html#DATATYPE-DATETIME-TABLE INTERVAL |}