Re: checkdate function question!

Henrik Hansen <hh@mailserver.dk> writes: > > I'm using the checkdate function to obviously check the date. Well when I > > check the date that is the year 2038 or grater it doesn't work. Is this the > > Unix Y2K thing? > > it's not y2k :) but it is a unix thing, the seconds from year 1900 variable > will run out and be set to zero (excatly on 19th jan 2038 at 03:14 am) > > > Also, if this is true is there a way to get around this > > problem? > > i dont know if there are any sulutions, i dont think there is, yet. If you have a database you can use some of its functions for timestamps storage. For example Postgres's timestamp type supports timestams up to year AD 1465001 with 1 microsecond resolution. This is not the best way, but will work if you really have to deal with those dates. -- Arcady Genkin Don't read everything you believe.