CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work. It
creates that table but
when you insert a value without time zone it stll appends -05 as time
zone(my datestyle is US and since my time is EST it appends 05 on its own
and that sucks )
----- Original Message -----
From: "Brian McCane" <bmccane@mccons.net>
To: "nimeshb" <nimeshb@syscon-intl.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, June 19, 2002 6:32 PM
Subject: Re: [ADMIN] time stamp
>
> CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ;
>
>
> On Wed, 19 Jun 2002, nimeshb wrote:
>
> > The datatype "timestamp" automatically adds zone in the field values.
> > i.e. If you insert a value 06-05-2002 15:03:08 (MM/DD/YYYY HH/MM/SS) it
would store as "06-05-2002 15:03:08-05". I don't want
> > last two digits 05 which represents timezone and determines how many hrs
you are ahead(or behind?) GMT.
> > Is there anyway to get rid of these digits(representing Zone)
> > Nimesh
> >
> >
>
> Wm. Brian McCane | Life is full of doors that won't
open
> Search http://recall.maxbaud.net/ | when you knock, equally spaced amid
those
> Usenet http://freenews.maxbaud.net/ | that open when you don't want them
to.
> Auction http://www.sellit-here.com/ | - Roger Zelazny "Blood of Amber"
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>