Re: [GENERAL] two digit years in inserts

2004-10-06 Thread Mike Nolan
> its not my data i am stuck moving this data from a sad access database > designed by a moron. anyway it means i will have to do alot of work on > the script to make it fix that, or just install an old version of pgsql > on a box here and pg_dump the table which seems easier. I've ported a lot

Re: [GENERAL] two digit years in inserts

2004-10-06 Thread Justin Wyer
Tom Lane wrote: Justin Wyer <[EMAIL PROTECTED]> writes: I have this problem, I wrote a script to insert data into a table, one of the columns is a birthdate now I only have the last two year digits, and this all worked fine. Until I did a portupgrade (i am running on bsd 5.2.1 and 4.8 and pos

Re: [GENERAL] two digit years in inserts

2004-10-06 Thread Tom Lane
Justin Wyer <[EMAIL PROTECTED]> writes: > I have this problem, I wrote a script to insert data into a table, one > of the columns is a birthdate now I only have the last two year digits, > and this all worked fine. Until I did a portupgrade (i am running on bsd > 5.2.1 and 4.8 and postgresql 7.3

[GENERAL] two digit years in inserts

2004-10-06 Thread Justin Wyer
I have this problem, I wrote a script to insert data into a table, one of the columns is a birthdate now I only have the last two year digits, and this all worked fine. Until I did a portupgrade (i am running on bsd 5.2.1 and 4.8 and postgresql 7.3.6 & 7.3.7 respectively) script worked fine bef