RE: [PHP-DB] odbc date
| From: | Andrew Hill | Date: | Mon, 31 Dec 2001 17:02:40 +0000 |
| Subject: | RE: [PHP-DB] odbc date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15280@lists.php.net to get a copy of this message | ||
George,
You can use the date() function in PHP to change the format:
http://www.php.net/manual/en/function.date.php
Or you can format it with odbc date syntax in your query { d 'YYYY-MM-DD' }
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: George Nicolae [mailto:geomasterweb@hotmail.com]
> Sent: Sunday, December 30, 2001 5:37 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] odbc date
>
>
> for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field,
> php will automatically convert it to 'yyyy/mm/dd hh:mm:ss' format
> regardless
> of the style of date you've denoted in Access
>
> how can I resolve this problem and print in a different format?
> --
>
>
> Best regards,
> George Nicolae
> IT Manager
> ___________________
> X-Playin - Professional Web Design
> www.x-playin.f2s.com
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>