RE: [PHP-WIN] date format problem with mssql_* functions
| From: | Darvin Andrioli | Date: | Mon, 12 May 2003 13:33:50 +0000 |
| Subject: | RE: [PHP-WIN] date format problem with mssql_* functions | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19865@lists.php.net to get a copy of this message | ||
Peter wrote
>
> but now I got real problem - the format of date values is really
> strange (if getting with mssql_fetch_row)
> and I don't know, where I can set date format for getting (and
> setting) data with mssql_* functions
> (with odbc it was ok, format was pure and clear)
>
Have a look to convert command in MSSQL documentation.
Here an example from my script:
select top 10 convert(char(10),DateTime_field,120) from MyTable
Darvin