From: | "Benjamin Gigot" <therealvaldor(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5672: Can't input julian days BC |
Date: | 2010-09-22 07:17:01 |
Message-ID: | 201009220717.o8M7H10X076516@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5672
Logged by: Benjamin Gigot
Email address: therealvaldor(at)hotmail(dot)com
PostgreSQL version: 8.4.4
Operating system: Ubuntu
Description: Can't input julian days BC
Details:
After trying to enter Confucius birthday (28th September 551BC) I had the
following error :
Query failed: ERROR: date/time field value out of range: "J1520447"
I then used a psql to try to enter different dates in the Julian days
format.
The date down to 0001-01-01 is working :
test=> INSERT INTO datetest (date) VALUES ('J1721426');
INSERT 0 1
But then under that it's not working anymore :
test=> INSERT INTO datetest (date) VALUES ('J1721425');
ERROR: date/time field value out of range: "J1721425"
LINE 1: INSERT INTO datetest (date) VALUES ('J1721425');
Documentation specify that dates can go down to J0, that is 4713BC.
Am I missing something ?
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2010-09-22 08:25:33 | Re: BUG #5661: The character encoding in logfile is confusing. |
Previous Message | Jeff Davis | 2010-09-22 07:05:23 | UNLISTEN bug |