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
> 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
"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.
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
"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,
"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
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
.
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
"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
gt; Para: pgsql-general@postgresql.org
> Cc: Carlos H. Reimer
> Assunto: Re: [GENERAL] Dates rejected
>
>
> Martijn van Oosterhout schrieb:
> > > create table tt_teste (datfis timestamp without time zone not null
> > > CHECK (datfis = trunc(datfis::timestamp without tim
Martijn van Oosterhout schrieb:
> > create table tt_teste (datfis timestamp without time zone not null
> > CHECK (datfis = trunc(datfis::timestamp without time zone)));
>
> What are you trying to do here? If you only want a date, why not just
> use a date type?
This is an other question ;-)
A
On Mon, Oct 16, 2006 at 12:22:04PM -0200, Carlos H. Reimer wrote:
> Hi,
>
> We´ve a simple insert that is not working. The strange thing is that all
> kind of date are working with the exception of 15/10 (DD/MM) dates.
>
> create table tt_teste (datfis timestamp without time zone not null
> CHEC
Carlos H. Reimer <[EMAIL PROTECTED]> schrieb:
>
> Hi,
>
> WeŽve a simple insert that is not working. The strange thing is that all kind
> of date are working with the exception of 15/10 (DD/MM) dates.
>
> create table tt_teste (datfis timestamp without time zone not null
> CHECK (datfis = tr
Hi,
We´ve a simple
insert that is not working. The strange thing is that all kind of date are
working with the exception of 15/10 (DD/MM) dates.
create table tt_teste (datfis timestamp without
time zone not null CHECK (datfis = trunc(datfis::timestamp without time
zone)));
INSERT INTO tt
14 matches
Mail list logo