Re: DBI returned timestamp does not include seconds

[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..