Re: time stamp

I am  migrating our database from ingres to postgres and I want a replica of
ingres database into postgres for
this I had to write a lot of scripts but I don't know how to take care of
this problem as postgres this
by default.When I retrieve it with a select query it comes with ZONE but you
are right may be
the programmers would be able to do whatever they want without any
problem.Thanks anyway !

Nimesh
----- Original Message -----
From: "Mark McEahern" <marklists@mceahern.com>
To: "nimeshb" <nimeshb@syscon-intl.com>; "Brian McCane" <bmccane@mccons.net>
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, June 20, 2002 10:54 AM
Subject: Re: [ADMIN] time stamp


> > 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 )
>
> Why do you care how pg stores the field?  Are you able to retrieve it and
do
> the stuff you need to do?
>
> // m
>
> -
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>