postgresql Data Types Date/ Time Types


Example

NameStorage SizeDescriptionLow ValueHigh ValueResolution
timestamp (without time zone)8 bytesboth date and time (no time zone)4713 BC294276 AD1 microsecond / 14 digits
timestamp (with time zone)8 bytesboth date and time, with time zone4713 BC294276 AD1 microsecond / 14 digits
date4 bytesdate (no time of day)4713 BC5874897 AD1 day
time (without time zone)8 bytestime of day (no date)00:00:0024:00:001 microsecond / 14 digits
time (with time zone)12 bytestimes of day only, with time zone00:00:00+145924:00:00-14591 microsecond / 14 digits
interval16 bytestime interval-178000000 years178000000 years1 microsecond / 14 digits
tsrangerange of timestamp without time zone
tstzrangerange of timestamp with time zone
daterangerange of date