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
