From: | "Aspire Something" <aspire420(at)hotpop(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Date Return must be As per Natural Calander |
Date: | 2003-02-23 16:22:10 |
Message-ID: | 001301c2db58$29f7b5e0$c9c832c0@societykotla |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs |
Hi all ,
Please Permit me to recive ur valuable knowledge and experience :-)
In the Postgresql Documentation (read it in /7.3.2/units-history.html) it has been given that Postgresql follows the Julian calander (Which indead is being used by my system by default )
So does it not mean when I add to a date (integer) it must return the
date as per the calendar :
i.e
The following sql statements
retuns date 1752-09-03
insted of 1752-09-14
you may do :
$cal 9 1752
on unix promt to verify (Windows user sorry ur calendar may not show dates <1970 !!! atleat mine does not )
<code>
select date('1752-09-02') + 1 as some_date ;
some_date
------------
1752-09-03
(1 row)
select date('1752-09-02') + interval'1 day' as some_day;
some_day
---------------------
1752-09-03 00:00:00
(1 row)
</code>
Now every thing above may sound stupid but if we in near future come accross the same situation how will the data base respond when my database relies 90% on the timestamp value
their will be total mismatch of calendar(Which people follow) and database returning dates.
Regards ,
Aspire
My Sys Config is
==================
Red Hate 7.2 Kernel 2.4.7-10 on an i686
Postgresql 7.3.2
GCC 3.0.2 20010905
=================
From | Date | Subject | |
---|---|---|---|
Next Message | mallah | 2003-02-23 16:37:59 | \d tablename with psql over slow links... |
Previous Message | Robert Prather | 2003-02-23 13:55:41 | PostgreSQL User On Mac OS X |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-02-23 19:55:03 | Re: psql -F problems |
Previous Message | Tom Lane | 2003-02-23 06:24:43 | Re: psql -F problems |