This is how I do it:

date("m/d/Y",strtotime(odbc_result($rs,"ts")))

where $rs is the result set and "ts" is the name of the field containing the datetime.

<>< Ryan

-----Original Message-----
From: Benjamin Walling [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 2:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MSSQL DateTime field formatting?


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?



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


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

Reply via email to