Casting and Timestamp - Mailing list pgsql-general

From Mark Gibson
Subject Casting and Timestamp
Date
Msg-id 449F0D31.1030403@gibsonsoftware.com
Whole thread Raw
Responses Re: Casting and Timestamp  (Mark Gibson <mark@gibsonsoftware.com>)
Re: Casting and Timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have unexpected results when trying to cast a string to a timestamp:

test=# select  TIMESTAMP WITH TIME ZONE '2006/06/25 06:00:00 GMT-5'
test-# ;
       timestamptz
------------------------
  2006-06-24 20:00:00-05


Seems that what I get is about 10 hours earlier than I expect...

Any ideas why this is happening?  Did I assume too much in the cast?

Thanks,
Mark

pgsql-general by date:

Previous
From: Mark Gibson
Date:
Subject: Re: casting... adding integer to timestamp
Next
From: Mark Gibson
Date:
Subject: Re: Casting and Timestamp