DBI returned timestamp does not include seconds

DBI returned timestamp does not include seconds

am 16.08.2007 12:42:48 von Ow.Mun.Heng

Querying SQL server.

Data in SQL Server is

7/31/2007 2:37:51 PM

Returned data from perl-dbi is

Jul 31 2007 02:37PM

There's missing seconds in the output. Anyone knows why?
Can I please get a clue here?

Re: DBI returned timestamp does not include seconds

am 21.08.2007 03:47:10 von Ow.Mun.Heng

On Thu, 2007-08-16 at 18:42 +0800, Ow Mun Heng wrote:
> Querying SQL server.
>
> Data in SQL Server is
>
> 7/31/2007 2:37:51 PM
>
> Returned data from perl-dbi is
>
> Jul 31 2007 02:37PM

Nailed it down to DBD::Sybase issue and posting here for the archives..

fix is to put in
$dbh->{syb_date_fmt} = 'ISO';

as a parameter..