http://www.perlmonks.org?node_id=1094060


in reply to Accessing Microsoft SQL Server from Linux using DBD::Sybase

A very useful and clear article, thank you!

Worth knowing: By default, if you use the tsql date commands, you get the date from DBD::Sybase in a rather inconvenient format, with the year, day and month like this: "Jul 8 2014".

If you add

$dbh->syb_date_fmt('ISO');

Just after you open the database handle, DBD::Sybase then presents date data in a more useful format, "2014-07-08".

More details at Stack Overflow:
http://stackoverflow.com/questions/14286821/perl-rewrite-sql-date-format/14287790#14287790

Replies are listed 'Best First'.
Re^2: Accessing Microsoft SQL Server from Linux using DBD::Sybase
by srini.here (Initiate) on Oct 16, 2014 at 14:53 UTC
    I get the following error :  perl: symbol lookup error: /usr/bin/perl5/DBI/1.607/exec/5.10/lib/perl5/auto/DBI/DBI.so: undefined symbol: Perl_Istack_sp_ptr But I can connect perfectly with the below:  /efs/dist/fsf/freetds/0.82/exec/bin/tsql -S DBName -I $HOME/freetds.conf -U userName -P passwOrd what might be the issue?