RES: RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
da em: terça-feira, 17 de outubro de 2006 00:02 > Para: [EMAIL PROTECTED] > Cc: Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > To discover if it works this way I´ve chan

RES: RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
> Cc: Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > To discover if it works this way I´ve changed the > /etc/localtime to relect > > the following timezone: &g

Re: RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > To discover if it works this way I´ve changed the /etc/localtime to relect > the following timezone: Um ... what PG version are you working with? 8.0 and up don't pay attention to /etc/localtime, because they have their own timezone info.

RES: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
outubro de 2006 21:38 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > The problem is related with the to_timestamp func

Re: RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > The problem is related with the to_timestamp function that returns +1 hour > offset only for the date 15/10/2006. The 15th october is the first day of > our day light change. The reason is that it's generating '2006-10-15 00:00:00-03' to start with,

Re: RES: [GENERAL] Dates rejected

2006-10-16 Thread Jorge Godoy
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > How can we explain the 01:00:00 hour that the to_date function returns for > date 15/10/2006? You haven't fixed your configuration and your machine is considering that you're in DST. Lots of machines here in Brazil that weren't updated / fixed by

RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
7 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: [GENERAL] Dates rejected > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > select to_date('16/10/2006','DD/MM/'); > >t

RES: RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
. Thanks in advance! Carlos > -Mensagem original- > De: Tom Lane [mailto:[EMAIL PROTECTED] > Enviada em: segunda-feira, 16 de outubro de 2006 16:27 > Para: [EMAIL PROTECTED] > Cc: Andreas Kretschmer; Pgsql-General@Postgresql.Org > Assunto: Re: RES: [GENERAL] Dates rej

Re: RES: [GENERAL] Dates rejected

2006-10-16 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > select to_date('16/10/2006','DD/MM/'); >to_date > - > 2006-10-16 00:00:00 > (1 row) Um... what have you done to to_date()? The standard version returns a date, not a timestamp: regression=# select to_date('15/10/20

RES: [GENERAL] Dates rejected

2006-10-16 Thread Carlos H. Reimer
Hi, I don´t know why the developers build in this way... but let me change a little bit my question. I´ve executed tree to_date functions but they give a strange answer for date 16/10/2006 (DD/MM/). select to_date('16/10/2006','DD/MM/'); to_date - 2006-10-16 0