>> RICHARDSON | TX | NULL | 0 | CX-2G10-146 | 146GB 10K 2GB
>> FC | NULL | 15 | NULL | -00-00 | -00-00 | NULL | 612
>> | NULL | NULL | Installed | NUCO INC | PREMIUM HARDWARE SUPPORT | 1926 |
>> -00-00 | -00-00 |
ppears the Julian date is adding a day to the date although that doesn’t
> materially impact my project. Thoughts?
>
> Hagen
>
>
>
> On 7/14/09 12:44 PM, "Michael Dykman" wrote:
>
>> Hagan,
>>
>> your premise looks reasonable enough (excepting
atement.. the system is expecting
> a string).. might you show us your schema and perhaps a print-out of
> your query after it has been rendered by perl?
>
>
> - michael dykman
>
> On Tue, Jul 14, 2009 at 2:23 PM, Hagen Finley wrote:
>> I am using mysql Server version:
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 into
