Skip Menu |

This queue is for tickets about the DBD-Sybase CPAN distribution.

Report information
The Basics
Id: 83197
Status: open
Priority: 0/
Queue: DBD-Sybase

People
Owner: Nobody in particular
Requestors: mgerardi [...] tribune.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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]
Download image001.png
image/png 7.8k
image001.png
This has nothing to do with DBI as far as I can see and if at all should be on the DBD::Sybase queue. It should also be noted I think I saw a post on perl monks which might be the same issue. Possibly this node -> http://perlmonks.org/?node_id=1017196. Martin -- Martin J. Evans Wetherby, UK