Re: 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"