[PHP-DB] MSSQL date format problem

[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 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



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MSSQL Date

[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 biggest beef is not being able to get seconds. Is there any way, with
SQL7, for me to return dates in a custom format? eg. 2001-07-15 00:51:32

-Gwilym



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]