MSSQL Date
| From: | Gwilym | Date: | Mon, 16 Jul 2001 00:12:46 +0000 |
| Subject: | MSSQL Date | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10421@lists.php.net to get a copy of this message | ||
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