Datetime problem

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

Hello there,

I'm with a little trouble with postgresql and date/time conversions:

- 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

Anybody can help me?

[]'s

Eric Lemes de Godoy Cintra
Analista de Sistemas Líder
Zanthus Sistemas e Equip. Automação S/A
Desenvolvimento de Software

eric(dot)lemes(at)zanthus(dot)com(dot)br
Fone: 55(11) 3750-7077

---
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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stef 2004-06-14 14:31:01 Re: Datetime problem
Previous Message Achilleus Mantzios 2004-06-14 13:34:44 Re: Datetime problem