Postgres Pro
Downloads
Home   >   mailing lists

Dates and year 2000 - Mailing list pgsql-sql

From Andy Marden
Subject Dates and year 2000
Date
Msg-id a4u6fh$orp$1@jupiter.hub.org
Whole thread Raw
List pgsql-sql
Tree view 
Am loading date fields from text in one table to date in another. Format of
the text dates is 'DD.MM.YY', so that's the format mask I use. Dates for
2001 work OK - '02.09.01' translates as '2001-09-02', but '02.09.00'
translates to '0001-09-02 BC'! The y2k.html part of the integrated doc says
that 70 - 69 equates 1970 - 2069.

Am I missing something?

Version 7.1.3 on RH 7.2 BTW

Cheers

Andy

pgsql-sql by date:

Previous
From: "D'laila Pereira"
Date:
Subject: SQL query (general)
Next
From: Henry Holland
Date:
Subject: Changing a column constraint?