| 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$l81.222079@monger.newsread.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
Thanks,
Curt Sififert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yury Don | 2000-01-25 11:31:18 | |
| Previous Message | Tom Lane | 2000-01-21 22:25:39 | Re: [BUGS] SELECT "bug"? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yury Don | 2000-01-24 05:50:18 | Re: [GENERAL] RE: stat failed on /usr/lib/pgsql/plpgsql.so; no file or directory |
| Previous Message | Lamar Owen | 2000-01-24 03:20:03 | Re: [GENERAL] RE: Where is the Database log file ? |