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.
Table 3-22. Some Valid Timestamp Formats
ISO-8601 date format, with time detailed to minutes, and PST time zone
European date format, with time detailed to microseconds
US date format, with time detailed to minutes in 24-hour time
25.06.1980 23:11:12 PM
German regional date format, with time detailed to seconds, and PM attached
|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.