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 по дате отправления: