Datetime problem - Mailing list pgsql-sql

From Eric Lemes
Subject Datetime problem
Date
Msg-id AIEBKHHFIIDLBADEGCPDIEKICAAA.eric.lemes@zanthus.com.br
Whole thread Raw
Responses Re: Datetime problem
Re: Datetime problem
Re: Datetime problem
List 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.lemes@zanthus.com.br
Fone: 55(11) 3750-7077

 
Attachment

pgsql-sql by date:

Previous
From: Willem de Jong
Date:
Subject: Re: sum ( time) problem
Next
From: Achilleus Mantzios
Date:
Subject: Re: Datetime problem