php-db | 2001071

[PHP-DB] MSSQL Date From: Gwilym (news <email protected>)
Date: 07/15/01

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: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>