Home > mailing lists

Datetime problem - Mailing list pgsql-sql

From	Eric Lemes
Subject	Datetime problem
Date	June 14, 2004 14:15:16
Msg-id	AIEBKHHFIIDLBADEGCPDIEKICAAA.eric.lemes@zanthus.com.br Whole thread Raw
Responses	Re: Datetime problem (Achilleus Mantzios <achill@matrix.gatewaynet.com>) Re: Datetime problem (Stef <svb@ucs.co.za>) Re: Datetime problem (Tom Lane <tgl@sss.pgh.pa.us>)
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

logo_assinatura.bmp

pgsql-sql by date:

Previous

From: Willem de Jong
Date: 14 June 2004, 02:32:33
Subject: Re: sum ( time) problem

Next

From: Achilleus Mantzios
Date: 14 June 2004, 14:27:12
Subject: Re: Datetime problem