Hello, - PostgreSQL 7.3.2 on i386-redhat-linux GCC 3.2.2 - Timezone: Brazil (GMT-3, I think).
I think my problem is with the time zone. Using a SET TIME ZONE GMT, the result is Ok. But I don't know how to work with time zones correctly. When I send a date to to_timestamp, pgsql thinks this date is in GMT? Thanks for all your help. []'s Eric Lemes > -----Mensagem original----- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nome de Tom Lane > Enviada em: segunda-feira, 14 de junho de 2004 11:56 > Para: Eric Lemes > Cc: [EMAIL PROTECTED] > Assunto: Re: [SQL] Datetime problem > > > "Eric Lemes" <[EMAIL PROTECTED]> 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
