Date Return must be As per Natural Calander

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
=================

Responses

Browse pgsql-admin by date

  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

Browse pgsql-bugs by date

  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