[PHP-DB] MSSQL date format problem

2003-07-14 Thread Peter Misun
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: -mm-dd hh:mm:ss[.fff] but wih using db-library there is: mmm dd hh:mmxx where xx

[PHP-DB] MSSQL Date

2001-07-15 Thread Gwilym
I'm experiencing a problem with returning dates from MSSQL. Firstly, I can't get it to return seconds. Secondly, the format seems to change occasionally. I can't pinpoint when. One format is 15 Jul 2001 12:51AM and the other is Jul 15 2001 12:51AM. I can code around this, but it's annoying. My