Historical dates in Timestamp
| От | Albert REINER |
|---|---|
| Тема | Historical dates in Timestamp |
| Дата | |
| Msg-id | 20010404130423.A2180@frithjof обсуждение исходный текст |
| Ответы |
Re: Historical dates in Timestamp
|
| Список | pgsql-sql |
Saluton,
I have a database with dates, some of which are historical dates.
When I wanted to enter May 28th, 812 I got an error message, had to
use 0812 for the year instead:
albert=> CREATE DATABASE test;
CREATE DATABASE
albert=> \c test
You are now connected to database test.
test=> CREATE TABLE dates (d timestamp);
CREATE
test=> insert into dates (d) values ('812-5-28');
ERROR: Bad timestamp external representation '812-5-28'
test=> insert into dates (d) values ('0812-5-28');
INSERT 81801 1
The same happens for BC dates:
test=> insert into dates (d) values ('812-5-28 BC');
ERROR: Bad timestamp external representation '812-5-28 BC'
test=> insert into dates (d) values ('0812-5-28 BC');
INSERT 81802 1
Is it really reasonable to enforce that the number of years is four
digits at least?
I'm running:
test=> SELECT version(); version
--------------------------------------------------------------------PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1,
compiledby gcc 2.95.1
(1 row)
Bye,
Albert.
В списке pgsql-sql по дате отправления: