MSSQL date format problem
| From: | Peter Misun | Date: | Mon, 14 Jul 2003 11:37:52 +0000 |
| Subject: | MSSQL date format problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29225@lists.php.net to get a copy of this message | ||
hi,
I have seen solution for my problem, but I couldn't find and I'm in a hurry - please help.
Problem is, how to set default datetime format while using mssql functions?
With ODBC, there is format: yyyy-mm-dd hh:mm:ss[.fff]
but wih using db-library there is: mmm dd yyyy hh:mmxx where xx is either AM or PM
how to set default datetime format?
I have used
ini_set("mssql.datetimeconvert","0");
in my php scripts and it works fine for MSSQL 7, but not for MSSQL 2000
please help
5o