| 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: | Whole Thread | Raw Message | 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 |