<programlisting>

TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'

</programlisting>

</para>

In a literal that has been determined to be <type>timestamp without time

<para>

In a value that has been determined to be <type>timestamp without time

zone</type>, <productname>PostgreSQL</productname> will silently ignore

any time zone indication.

That is, the resulting value is derived from the date/time

fields in the inputvalue, and is not adjusted for time zone.

fields in the inputstring, and is not adjusted for time zone.

</para>

<para>

For <type>timestamp with time zone</type>, the internally stored

value is always in UTC (Universal

Coordinated Time, traditionally known as Greenwich Mean Time,

<acronym>GMT</acronym>). An input value that has an explicit

time zone specified is converted to UTC using the appropriate offset

For <type>timestamp with time zone</type> values, an input string

that includes an explicit time zone will be converted to UTC

(<glossterm linkend="glossary-utc">Universal Coordinated

Time</glossterm>) using the appropriate offset

for that time zone. If no time zone is stated in the input string,

then it is assumed to be in the time zone indicated by the system's

<xref linkend="guc-timezone"/> parameter, and is converted to UTC using the

offset for the <varname>timezone</varname> zone.

In either case, the value is stored internally as UTC, and the

originally stated or assumed time zone is not retained.

</para>

<para>

</glossdef>

</glossentry>

<glossentry>

<glossterm>GMT</glossterm>

<glosssee otherterm="glossary-utc" />

</glossentry>

<glossentry id="glossary-grant">

<glossterm>Grant</glossterm>

<glossdef>

</glossdef>

</glossentry>

<glossentry id="glossary-utc">

<glossterm>UTC</glossterm>

<glossdef>

<para>

Universal Coordinated Time, the primary global time reference,

approximately the time prevailing at the zero meridian of longitude.

Often but inaccurately referred to as GMT (Greenwich Mean Time).

</para>

</glossdef>

</glossentry>

<glossentry id="glossary-vacuum">

<glossterm>Vacuum</glossterm>

<glossdef>