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

'now' is the future

From: Robert Church <churchr(at)hurrah(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 'now' is the future
Date: 1998-11-09 20:05:29
Message-ID: 13895.19209.501246.2866@sandoz.hurrah.com (view raw or flat)
Thread:
Lists: pgsql-general
PostgreSQL 6.3.4 on a Debian GNU/Linux Alpha box is returning dates
far into the future. Has anyone else encountered this?

Sample psql session:

template1=> select 'now'::datetime;
?column?                
------------------------
Thu Dec 16 23:08:02 2134
(1 row)


Might this be a silly 64-bit portability problem somewhere?

pgsql-general by date

Next:From: Bruce MomjianDate: 1998-11-09 20:57:09
Subject: Re: [GENERAL] Incrementing a Serial Field
Previous:From: David HartwigDate: 1998-11-09 18:37:33
Subject: Re: [GENERAL] postgreSQL 6.3.2 and AIX

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