Re: [SQL] Historical dates in Timestamp

2001-04-04 Thread Tom Lane
"Albert REINER" <[EMAIL PROTECTED]> writes: > Is it really reasonable to enforce that the number of years is four > digits at least? I believe so. Without that cue it's pretty difficult for the timestamp parser even to figure out which field is intended to be the year, let alone whether you'd li

[SQL] Historical dates in Timestamp

2001-04-04 Thread Albert REINER
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 TABL