Re: Convert historical dates from UTC

2005-03-22 Thread Mike Rykowski
At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote: What do you mean by "historical"? Are we talking 20th century dates or something BCE? Dates that could be a couple of years old. - Mike Rykowski IT - Telecommunication and Network Services (847) 467-7335 [EMAIL PROTECTED] -- MySQL General Maili

Re: Convert historical dates from UTC

2005-03-22 Thread SGreen
Mike Rykowski <[EMAIL PROTECTED]> wrote on 03/22/2005 11:12:41 AM: > Hello, > > I have historical dates in datetime format and they are in UTC. I'd like > to convert them to localtime. Can this be done with mysql 3.23.22? It > looks like 4.1 can handle this, but I won't be upgrading in a whi

Convert historical dates from UTC

2005-03-22 Thread Mike Rykowski
Hello, I have historical dates in datetime format and they are in UTC. I'd like to convert them to localtime. Can this be done with mysql 3.23.22? It looks like 4.1 can handle this, but I won't be upgrading in a while. If not, does anyone know of a perl module that takes mysql formated dateti