Re: Datetime problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Lemes" <eric(dot)lemes(at)zanthus(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Datetime problem
Date: 2004-06-14 14:56:05
Message-ID: 164.1087224965@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Eric Lemes" <eric(dot)lemes(at)zanthus(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message hook 2004-06-14 16:02:06 max value from join
Previous Message Stef 2004-06-14 14:31:01 Re: Datetime problem