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$ (view raw, whole thread or download thread mbox)
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)


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-2017 The PostgreSQL Global Development Group