The documentation of extract clearly states:. Timestamp with time zone, relative to the current date in the target time zone =# select now(); now ----- 2014-07-05 02:58:03.598569+02 (1 row) However, PostgreSQL parses this into the much more confusing "timezone('UTC'::text, ('now'::text)::timestamp(6) with time zone)" which is what is appearing on my generated documentation. I'm currently using CURRENT_TIMESTAMP AT TIME ZONE 'UTC' and inserting into columns defined as TIMESTAMP WITHOUT TIME ZONE which appears to work. For timestamp with time zone values, the number of seconds since 1970-01-01 00:00:00 UTC (can be negative); for date and timestamp values, the number of seconds since 1970-01-01 00:00:00 local time; for interval values, the total number of seconds in the interval. This PostgreSQL tutorial explains how to use the PostgreSQL current_timestamp function with syntax and examples. EXTRACT, date_part EXTRACT(field FROM source) The extract function retrieves subfields such as year or hour from date/time values.source must be a value expression of type timestamp, time, or interval. statement_timestamp() It returns the start time of the current statement. Default Postgres time zone. The timestamptz data type in PostgreSQL is essentially a timestamp string with a timezone attached to it. now ( ) → timestamp with time zone. The following illustrates the syntax of the CURRENT_TIME function:. The PostgreSQL CURRENT_TIME function returns the current time with time zone.. Syntax. 2.Postgresql stores timestamptz datatype in UTC format. This page has examples for producing the timestamp value for "9AM, Yesterday, in Los Angeles". You still get the date for the current time zone, which agrees with the display of the timestamp. ... CURRENT_TIMESTAMP or now() if you want a timestamp with time zone, The following illustrates the syntax of the CURRENT_TIME function:. (Expressions of type date will be cast to timestamp and can therefore be used as well.) In most cases, a combination of date, time, timestamp without time zone, and timestamp with time zone should provide a complete range of date/time functionality required by any application. Postgres timestamptz. CURRENT_DATE. The same point in time translates to the next day in parts of Europe, when it is past 4 p.m. in California for instance. The CURRENT_TIME function accepts one optional argument:. If you want to know how many seconds passed since Jan. 1 st 1970 in your time zone, use A recent example was to try to assign an time to ‘6am’. The CURRENT_TIME function accepts one optional argument:. It is fairly easy to input data. field is an identifier or string that selects what field to extract from the source value. 3: CURRENT_TIMESTAMP. 3: clock_timestamp() It returns the actual current time, and therefore its value changes even within a single SQL command.