Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Brian McCaneDate: 2002-06-19 23:28:07
Subject: Re: index keeps on growing
Previous:From: Tom LaneDate: 2002-06-19 21:38:10
Subject: Re: index keeps on growing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group