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
EMAIL PROTECTED]>
> Cc: "Postgresql"
> Sent: Wednesday, January 18, 2006 10:03 AM
> Subject: Re: [GENERAL] Dates
>
>
> > On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
> >> Hi Folks
> >>
> >> I have a column for date which defaults to t
Perhaps you have a solution??
Bob
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Wednesday, January 18, 2006 10:03 AM
Subject: Re: [GENERAL] Dates
On Wed, 2006-0
On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
> Hi Folks
>
> I have a column for date which defaults to the ambigous 2005-1-1
> format.
>
> The documantation indicates how to change this to the unambigous Jan 1
> 2005, but the instructions aren't clear to me.
Actually, if the year comes first
Hi Folks
I have a column for date which defaults to the
ambigous 2005-1-1 format.
The documantation indicates how to change this to
the unambigous Jan 1 2005, but the instructions aren't clear to me.
Any help will be appreciated.
Bob Pawley
Subtracting two dates/timestamps will return an interval. So
select now()::date - '2004-01-13'::date
returns 34.
Is this what you need?
On Feb 16, 2004, at 2:01 PM, MaRCeLO PeReiRA wrote:
Hi Guys,
I am in troubles with some dates.
"I need to know the difference, in days, between two
dates."
Well, i
19 matches
Mail list logo
