Casting and Timestamp

From: Mark Gibson <mark(at)gibsonsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Casting and Timestamp
Date: 2006-06-25 22:24:49
Message-ID: 449F0D31.1030403@gibsonsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Gibson 2006-06-25 22:36:51 Re: Casting and Timestamp
Previous Message Mark Gibson 2006-06-25 22:21:10 Re: casting... adding integer to timestamp