MSSQL DateTime field formatting?
| From: | Benjamin Walling | Date: | Tue, 14 May 2002 20:59:03 +0000 |
| Subject: | MSSQL DateTime field formatting? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19185@lists.php.net to get a copy of this message | ||
I can't seem to find a way to format the field that comes back from my
DateTime fields in MSSQL Server. For example, '2002-05-13' shows in Query
Analyzer as 2002-05-13 00:00:00.000. If I echo it from PHP, I get May 13
2002 12:00AM. date() won't take it. strftime() won't take it. What do I
need to do to convert this to a time PHP likes?