Re: How to timestamp

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Martin Jacobs <100(dot)179370(at)germanynet(dot)de>, "Alex Cheung Tin Ka [CD]" <tkcheung(at)vtc(dot)edu(dot)hk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to timestamp
Date: 2002-01-08 02:56:48
Message-ID: 3C3A5FF0.EF557C9A@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Some slight clarifications...

> > I would like to know how to create a timestamp value without time zone.
> There is a data type without time zone. It's just called
> 'timestamp'

This is mostly true for the upcoming version 7.2, but is not the case
for older versions (it could be, and probably should be, but isn't ;).
Here are some details on the differences, and how those differences are
going away:

o timestamp with/without time zone all map to the same "timezone aware"
data type in versions prior to 7.2.

o For 7.2, "timestamp" maps to "timestamp with time zone" to help with
upgrading from 7.1 and before. For 7.3, it is likely that we will
conform more closely to the SQL9x standard and have it map to "timestamp
without time zone". But imho y'all should be using timezones in most
cases anyway. You can get "timestamp without time zone" by specifying it
explicitly.

o In any version, you can control which time zone is used by your
application. So if you don't want it shifting around to reflect local
reality, then you can force it to a specific offset or to zero. Things
will behave pretty much like a "zoneless" data type.

hth

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jason Kwok 2002-01-08 02:58:32 How to get the IP connecting my pg server?
Previous Message Gyozo Papp 2002-01-08 02:38:12 REQUEST: database security issues in PHP manual