Re: date format problem with mssql_* functions
| From: | Peter Misun | Date: | Mon, 12 May 2003 14:04:48 +0000 |
| Subject: | Re: date format problem with mssql_* functions | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19869@lists.php.net to get a copy of this message | ||
maybe, it helps
but I don't want to rewrite tons of sql commands :-(
I need some general aid ;)
5o
Darvin Andrioli wrote:
> 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