Date Translation Issues

2009-07-14 Thread Hagen Finley
I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do is run perl¹s Spreadsheet::ParseExcel module with Time::JulianDay to reformat excel dates to insert properly

Re: Date Translation Issues

2009-07-14 Thread Hagen Finley
, Jul 14, 2009 at 2:23 PM, Hagen Finleyfinha...@comcast.net wrote: I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do is run perl¹s Spreadsheet::ParseExcel module

Re: Date Translation Issues

2009-07-14 Thread Michael Dykman
of your query after it has been rendered by perl?  - michael dykman On Tue, Jul 14, 2009 at 2:23 PM, Hagen Finleyfinha...@comcast.net wrote: I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert

Re: Date Translation Issues

2009-07-14 Thread Hagen Finley
by perl?  - michael dykman On Tue, Jul 14, 2009 at 2:23 PM, Hagen Finleyfinha...@comcast.net wrote: I am using mysql Server version: 5.1.31 MySQL Community Server (GPL) on a MAC 10.5 host. I am having some strange date translation issues when I insert dates into my tables. What I do