RES: [SQL] Datetime problem

2004-06-14 Thread Eric Lemes
date is in GMT? Thanks for all your help. []'s Eric Lemes > -Mensagem original- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] nome de Tom Lane > Enviada em: segunda-feira, 14 de junho de 2004 11:56 > Para: Eric Lemes > Cc: [EMAIL PROTECTED] > Assu

[SQL] Datetime problem

2004-06-14 Thread Eric Lemes
Hello there,   I'm with a little trouble with postgresql and date/time conversions:   - select to_timestamp('2004 10 10 00 00 00', ' MM DD HH MI SS')   the output is:   - 2004-10-09 23:00:00-03   Anybody can help me?     []'s   Eric Lemes de Godoy Cintr