From: Eric Lemes <eric.lemes@zanthus.com.br>
To: pgsql-sql@postgresql.org
Subject: RES: Datetime problem
Date: Mon, 14 Jun 2004 13:20:14 -0300
Message-ID: <AIEBKHHFIIDLBADEGCPDCEKLCAAA.eric.lemes@zanthus.com.br> (raw)
In-Reply-To: <164.1087224965@sss.pgh.pa.us>
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@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]Em nome de Tom Lane
> Enviada em: segunda-feira, 14 de junho de 2004 11:56
> Para: Eric Lemes
> Cc: pgsql-sql@postgresql.org
> Assunto: Re: [SQL] Datetime problem
>
>
> "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
>
> ---------------------------(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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: eric.lemes@zanthus.com.br
Subject: Re: RES: Datetime problem
In-Reply-To: <AIEBKHHFIIDLBADEGCPDCEKLCAAA.eric.lemes@zanthus.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox