tecmbg has asked for the wisdom of the Perl Monks concerning the following question:
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. 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?
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Using 64 bit DBD with Sybase 15
by afoken (Chancellor) on Feb 05, 2013 at 18:39 UTC | |
by Anonymous Monk on Feb 11, 2013 at 19:16 UTC | |
Re: Using 64 bit DBD with Sybase 15
by mpeppler (Vicar) on Feb 05, 2013 at 18:24 UTC | |
by Anonymous Monk on Feb 06, 2013 at 20:06 UTC | |
by mpeppler (Vicar) on Feb 07, 2013 at 14:10 UTC | |
by tecmbg (Initiate) on Feb 07, 2013 at 16:46 UTC | |
by mpeppler (Vicar) on Feb 08, 2013 at 09:55 UTC |
Back to
Seekers of Perl Wisdom