|
Posted by thib΄ on 01/14/08 23:33
Martin wrote:
> I'm retrieving some records from a database. One of the fields
> contains a date/time. I would like to format it as I send it out to
> the table in the displayed page.
>
> Can some one please tell me how I can/should do that? Or possibly
> point me to an on-line explanation?
>
> Thanks
>
> ps: if it makes any difference, the data is coming from a MS Access
> MDB file which I'm reading in via ODBC.
Don't know much about Access but I think you can use some of its internal
functions to return the a formatted date (like datepart() if I remember
well). Maybe you could get more help in comp.databases.ms-access.
Anyway, if you manage to get the 'intact' value in PHP, you've many string
functions (check the man) for formatting, or you can use date() if it's a
UNIX timestamp (but I don't think it is).
-thibΒ΄
[Back to original message]
|