Postgres Pro
Downloads
Home   >   mailing lists

Re: Datetime problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: Datetime problem
Date
Msg-id 164.1087224965@sss.pgh.pa.us
Whole thread Raw
In response to Datetime problem  ("Eric Lemes" <eric.lemes@zanthus.com.br>)
Responses RES: Datetime problem  ("Eric Lemes" <eric.lemes@zanthus.com.br>)
List pgsql-sql
Tree view 
"Eric Lemes" <eric.lemes@zanthus.com.br> writes:
> - select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS')
> the output is:
> - 2004-10-09 23:00:00-03

What PG version is this, on what platform, and what's your current
timezone setting?
        regards, tom lane

pgsql-sql by date:

Previous
From: Stef
Date:
Subject: Re: Datetime problem
Next
From: hook
Date:
Subject: max value from join