DBI returned timestamp does not include seconds
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
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..
