The PostgreSQL timestamp combines the functionality of the PostgreSQL date and time types into a single data type. The syntax of a timestamp value consists of a valid date format, followed by at least one whitespace character, and a valid time format. It can be followed optionally by a time zone value, if specified.

Combinations of all date and time formats listed in Table 3-15 and Table 3-20 are each supported in this fashion. Table 3-22 illustrates some examples of valid timestamp input.

Table 3-22. Some Valid Timestamp Formats

	Time Zones and Timestamps
	While PostgreSQL supports the syntax of creating a column or value with the type timestamp without time zone , as of PostgreSQL 7.1.2 the resultant data type still contains a time zone.