[RESOLVED] Date format

[phprooky]

Hi everyone,
I have a database on mySql with 4 fields and one of them is defined as follows: datetime.
Then I have a select where I call 4 fields of that table including date, but I want to bring the date with a diferent format to the one I am recording right now. The way I am recording the date is: yyyy-dd-mm hh:mm:ss
I want to bring the date with this format: June 18 2010, 2:45 PM
This is the select I have:

select date("F j, Y, g:i a"), field2, field3, field4 from my_table order by id desc limit 1"

Can anyone please help me?

[bradgrafelman]

You're trying to use a PHP function in the middle of a SQL query string.

Instead, you should be using MySQL's DATE_FORMAT() function instead.

[phprooky]

Thanks for your help Brad and sorry for the delay!!