Posted by Angelo Zanetti on 03/24/05 13:33

yeah i know but its used for other calculations thats why i format it
with PHP!!
thanks anyway

Chris Ramsay wrote:

>Angelo,
>
>slightly OT , but as a point of interest perhaps, $row['date'] seemed
>to indicate that your date comes out of a DB - you can date format
>stuff with sql too - I find that useful sometimes...
>
>With MySQL for example, if your date field is called 'myDate' you can
>do the following in the query:
>
>SELECT ... DATE_FORMAT(myDate, %d %b %Y) AS date ,....FROM.....
>
>which formats $row['date'] as '25 mar 2005'...
>
>rgds
>
>chris
>
>
>

--

Angelo Zanetti
Z Logic
[c] +27 72 441 3355
[t] +27 21 464 1363
[f] +27 21 464 1371
www.zlogic.co.za

• Next in forum: Re: [PHP] Listing directory, return none if only one file
• Prev in forum: Re: [PHP] convert date format-SOLVED
• Thread view: Re: [PHP] convert date format-SOLVED

[Reply to this message]