Re: how should MS Access DATETIME be handled in PHP?
| From: | Bing Du | Date: | Thu, 20 Apr 2006 13:42:30 +0000 |
| Subject: | Re: how should MS Access DATETIME be handled in PHP? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-234385@lists.php.net to get a copy of this message | ||
> I don't know if MS Access will behave the same, but in MySQL you can
> have a query like so:
>
> SELECT *, DATE_FORMAT(end_date, '%d %m %Y') as end_date_formatted FROM
> projects;
>
> And it will retrieve all columns from your projects table, plus the
> extra one you've created on the fly, and it will be named
> "end_date_formatted".
Great. Thanks, John. Yes, it works for Access as well.
Bing