time stamp

From: "nimeshb" <nimeshb(at)syscon-intl(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: time stamp
Date: 2002-06-19 22:28:38
Message-ID: 001e01c217e0$a898e220$110a11ac@sysconintl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2002-06-19 23:28:07 Re: index keeps on growing
Previous Message Tom Lane 2002-06-19 21:38:10 Re: index keeps on growing