From: | David Sauer <davids(at)penguin(dot)cz> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org, pgsql-bugs(at)postgreSQL(dot)org |
Subject: | problem with date |
Date: | 1999-10-27 19:17:27 |
Message-ID: | m2wvs8mx4o.fsf@chameleon.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general |
Hello,
I have problem with date:
# current date from OS prompt ...
% LC_ALL=C date
Wed Oct 27 21:08:56 CEST 1999
david=> select date('now');
date
----------
01-01-2000
(1 row)
I expect current date, not 1.1.2000 ... interesting solution of Y2K problem,
but unusable ...
david=> select date('now'::date);
date
----------
10-27-1999
(1 row)
This works, but why I need cast ?
david=> select date('hhhh');
date
-------------
11--2-4714 BC
I expect something like 'Bad external representation ....'
And finally, I have question: is there difference between
"date('now')" and "date(now())" ?
My pgsql version:
david=> select version();
version
-------------------------------------------------------------
PostgreSQL 6.5.2 on i586-pc-linux-gnu, compiled by gcc 2.95.1
(1 row)
I have glibc from RH 6.1.
Thanks,
--
* David Sauer, student of Czech Technical University
* electronic mail: davids(at)penguin(dot)cz (mime compatible)
From | Date | Subject | |
---|---|---|---|
Next Message | ednut | 1999-10-28 09:20:42 | Re: Linux/Postgres 6.5 problems using jdbc w/jdk1.2 |
Previous Message | Tom Lane | 1999-10-27 14:28:11 | Re: [SQL] Date comparisons |
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 1999-10-27 20:21:24 | Re: [GENERAL] foreign key |
Previous Message | Font | 1999-10-27 19:16:27 | Generic ODBC and column alias questions (fwd) |