Does PHP strip out the seconds from a SQL Server datetime field?
| From: | Alex Gemmell | Date: | Tue, 06 Dec 2005 17:14:36 +0000 |
| Subject: | Does PHP strip out the seconds from a SQL Server datetime field? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40762@lists.php.net to get a copy of this message | ||
Hello!
I'm using PHP 4.4.1 and pulling out records from a SQL Server database. I use the mssql extension in PHP to connect to SQL Server. My website works fine for the most part but I have noticed something odd with the dates returned from SQL Server.
In my SQL Server table I have many datetime fields. For example I can clearly see (using Enterprise Manager) the field "fldDateCreated" contains the datetime "06/12/2005 16:20:35" but oddly when I extract this field into a PHP variable the variable contains this: "Dec 6 2005 4:20PM".
Annoyingly I lose the seconds and I need the entire date and time. Can anyone explain why the datetime is getting "converted"? What is doing it (presumably PHP) and how can I get it to stop?
FYI: I use "mssql_pconnect()" to connect to the SQL Server database and "mssql_fetch_assoc()" to extract each row.
Thanks for any help offered!
Alex