Re: Using 64 bit DBD with Sybase 15

On 2/7/13 9:53 AM, Gerardi, Mark wrote:
Did you set a default date format in the connection?

This will not work with a connection made thru freetds; you have to 
compile against sybase middleware.

terry

> 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’m using DBD version 1.622 btw…
>   
> Thanks!
>   
> Mark Gerardi | Senior Software Engineer
>