Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^3: Using 64 bit DBD with Sybase 15

by mpeppler (Vicar)
on Feb 07, 2013 at 14:10 UTC ( #1017663=note: print w/ replies, xml ) Need Help??


in reply to Re^2: Using 64 bit DBD with Sybase 15
in thread Using 64 bit DBD with Sybase 15

Is this with the exact same version of OpenClient, with just the 32/64 bit difference?

Because the 64bit data you get is more correct - and is also what I get with a 32bit 15.7 client:

use strict; use DBI; my $dbh = DBI->connect('dbi:Sybase:server=foo', 'user, '***'); my $sth = $dbh->prepare("select convert(date, getdate()), convert(time +, getdate())"); $sth->execute; while(my $r = $sth->fetch) { print "@$r\n"; }
which outputs:
$ perl /tmp/date.pl Feb 7 2013 3:06PM
And to me that's as it should be - you're asking for just the date, so no time portion is displayed, or just the time, and no date portion is displayed.

This is with DBD::Sybase 1.14, btw.

Michael


Comment on Re^3: Using 64 bit DBD with Sybase 15
Select or Download Code
Re^4: Using 64 bit DBD with Sybase 15
by tecmbg (Initiate) on Feb 07, 2013 at 16:46 UTC
    It does seem more correct, but I don't believe it should require me to change the code? Shouldn't this be backward compatible?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1017663]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2015-07-05 06:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls