BUG #5672: Can't input julian days BC
| От | Benjamin Gigot |
|---|---|
| Тема | BUG #5672: Can't input julian days BC |
| Дата | |
| Msg-id | 201009220717.o8M7H10X076516@wwwmaster.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #5672: Can't input julian days BC
|
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5672
Logged by: Benjamin Gigot
Email address: therealvaldor@hotmail.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 ?
В списке pgsql-bugs по дате отправления: