RES: Datetime problem

From: "Eric Lemes" <eric(dot)lemes(at)zanthus(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: RES: Datetime problem
Date: 2004-06-14 16:20:14
Message-ID: AIEBKHHFIIDLBADEGCPDCEKLCAAA.eric.lemes@zanthus.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]Em nome de Tom Lane
> Enviada em: segunda-feira, 14 de junho de 2004 11:56
> Para: Eric Lemes
> Cc: pgsql-sql(at)postgresql(dot)org
> Assunto: Re: [SQL] Datetime problem
>
>
> "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
>
> ---------------------------(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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jaime Casanova 2004-06-14 16:49:34 query with =ALL
Previous Message hook 2004-06-14 16:02:06 max value from join