Skip site navigation (1) Skip section navigation (2)

Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps

From: Oliver Siegmar <oliver(at)siegmar(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Date: 2005-04-20 16:07:16
Message-ID: 200504201807.16908.oliver@siegmar.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Tom,

On Wednesday 20 April 2005 17:57, Tom Lane wrote:
> "Oliver Siegmar" <oliver(at)siegmar(dot)net> writes:
> > select '10.10 secs ago'::interval;
> >
> >      interval
> > -------------------
> >  @ 10.-10 secs ago
> > (1 row)
>
> What datestyle are you using?

Non-ISO (Postgres in that case), but the handling for non-ISO is all the same 
in interval.c ...


ISO works fine -

   interval
--------------
 -00:00:10.10
(1 row)



Oliver

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-04-20 16:10:45
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps
Previous:From: Tom LaneDate: 2005-04-20 15:57:37
Subject: Re: BUG #1609: Bug in interval datatype for 64 Bit timestamps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group