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]