From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> |
---|---|
To: | PostgreSQL-SQL <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Historical dates in Timestamp |
Date: | 2001-04-04 11:04:23 |
Message-ID: | 20010404130423.A2180@frithjof |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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, compiled by gcc 2.95.1
(1 row)
Bye,
Albert.
From | Date | Subject | |
---|---|---|---|
Next Message | Cedar Cox | 2001-04-04 12:32:57 | max( bool )? |
Previous Message | Algirdas Šakmanas | 2001-04-04 11:03:11 | outer joins |