Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?

2005-12-06 Thread Fen Lu
Try these for a test, I haven't check it~ $mytime=strtotime($stime) date('Y-m-d H:i:s',$mytime); -- >From : Fen lu

Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?

2005-12-06 Thread Fen Lu
I think there's nothing to your 'mssql_pconnect()' ~ As far as I known, in Oracle, the 'datetime' is stored as a 13 integer, it's a Unix timestamp so you won't lose any microsecond while save the 'datetime' but I didn't found how to do with your problem~

Re: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field? SOLVED

2005-12-06 Thread Alex Gemmell
Thanks Martin, it's definitely what is coming back from the database (I use Zend Studio to debug and can watch it happening). Actually it appears there is a default setting for the mssql extension that I was unaware of. I have to set the following in my php.ini to force the extension to keep

RE: [PHP-DB] Does PHP strip out the seconds from a SQL Server datetime field?. .

2005-12-06 Thread Norland, Martin
How are you printing/extracting this information? I find it very unlikely that it's returning that string - it would eliminate any localization opportunities as well as time conversion / math operations. Use print_r() to print the contents returned from SQL Server directly, if you're using date