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

date('now') returns 12/31/99?

From: "Curt Siffert" <siffert(at)museworld(dot)com>
To: pgsql-bugs(at)postgresql(dot)org(dot)pgsql-questions(at)postgresql(dot)org
Subject: date('now') returns 12/31/99?
Date: 2000-01-24 05:49:05
Message-ID: lJRi4.4957$ (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-general
Hi, on my box I do get the correct date if I type "date" from the shell.
When I'm in psql and I insert a row with a "date" field using "date('now')",
and then select it back out, it says 12-31-99.

What does postgres ask of the system to get the date?  Could this be a Y2K
bug with my bios or is there something else I should check?

This is Redhat 6.0 on a P233 running postgresql-6.5.3-3

Curt Sififert

pgsql-bugs by date

Next:From: Yury DonDate: 2000-01-25 11:31:18
Previous:From: Tom LaneDate: 2000-01-21 22:25:39
Subject: Re: [BUGS] SELECT "bug"?

pgsql-general by date

Next:From: Yury DonDate: 2000-01-24 05:50:18
Subject: Re: [GENERAL] RE: stat failed on /usr/lib/pgsql/; no file or directory
Previous:From: Lamar OwenDate: 2000-01-24 03:20:03
Subject: Re: [GENERAL] RE: Where is the Database log file ?

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