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

Re: 6.5.0 datetime bug?

From: gravity(at)dds(dot)nl
To: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: 6.5.0 datetime bug?
Date: 2000-03-31 08:21:34
Message-ID: 20000331102133.A9135@node10065.a2000.nl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Mar 30, 2000 at 01:48:27PM -0600, Ross J. Reedstrom wrote:
> > testtime=> select date_part('day', '3-26-2000'::timestamp-'3-6-2000'::timestamp) as days;
> >   20
> > testtime=> select date_part('day', '3-27-2000'::timestamp-'3-6-2000'::timestamp) as days;
> >   20
> Hmm, I happen to have a 6.5.0 system sitting here: It works there, so I suspect
> something with your local operating system config. Are you running LOCALE enabled?
> Since the same version works on my system, others reports of higher versions working
> for them probably don't mean much.
> Ross

now, this is weird.

no idea if I have LOCALE enabled, I don't use it that's for sure.

anyone?

tinus.

(I'll try upgrading anyhow)

Responses

pgsql-hackers by date

Next:From: Sergey V. MikheevDate: 2000-03-31 09:17:50
Subject: Postresql & triggers
Previous:From: Thomas LockhartDate: 2000-03-31 06:24:20
Subject: Re: BIT datatype

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