[PHP-DB] MSSQL DateTime field formatting?

2002-05-14 Thread Benjamin Walling
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

RE: [PHP-DB] MSSQL DateTime field formatting?

2002-05-14 Thread Ryan Jameson (USA)
] 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

Re: [PHP-DB] MSSQL DateTime field formatting?

2002-05-14 Thread Michael Bretterklieber
Hi, get the latest PHP4 and set set php.ini-param mssql.datetimeconvert to Off the the MSSQL-Module then returns datetime-values in this format: -MM-DD HH24:MI:SS bye, Benjamin Walling wrote: I can't seem to find a way to format the field that comes back from my DateTime fields in