Subject: | Using 64 bit DBD with Sybase 15 |
Date: | Thu, 7 Feb 2013 16:06:53 +0000 |
To: | "bug-DBI [...] rt.cpan.org" <bug-DBI [...] rt.cpan.org> |
From: | "Gerardi, Mark" <mgerardi [...] tribune.com> |
Has anyone had the chance to use the 64 bit versions of DBD Sybase using dates/times? I'm pulling out a date from Sybase 15, with the latest version of ctlib, and getting weird results.
By weird, I mean the date field (defined as date in the database), returns "Jan 4 2013 12:00am" as "Jan 4 2013". A field (defined as time in the database), returns "Jan 1 1900 5:00pm" as "5:00pm". In 32 bit, the dates return as "Jan 4 2013 12:00am" and "Jan 1 1900 5:00pm" respectively.
This same function works fine on the 32 bit side. It does work properly if a "convert(char(20, date)" is used in the query, but we don't want to change the code if possible. Without the convert, it is just pulling the date from a date column is chopping off the time when it is midnight. Also, if the date is 1/1/1900, its only outputting the time, without the date at all. We've tried multiple versions of DBD, still no luck. Any suggestions?
I understand that Sybase 15 defines types as strictly date and time respectively, but I would think the code should behave the same way in 32 or 64 bit.
I'm using DBD version 1.622 btw...
Thanks!
Mark Gerardi | Senior Software Engineer
40 Media Drive, Queensbury NY 12804
Phone: 518.792.9914 x4124
Web: TribuneMediaServices.com<http://www.tribunemediaservices.com/> | Email: mgerardi@tribune.com<mailto:*yourname*@tribune.com>
[cid:132400A6-D8DB-4D91-A6CB-57847CCED136]