No date formatting options in DW for PHP?

[AdrianLe]

So I noticed that DW has date formating options for recordset columns for ASP, but not for PHP.  I need to format a mySQL date and I've seen instructions out there on the net, and will probably go do the research, but anyone have an extension or something that will provide this functionality in DW???

[David_Powers]

The normal way to format a MySQL date is by using the DATE_FORMAT() function in the SQL query. Use an alias in the query to make it easier to display the result. For example:

SELECT DATE_FORMAT(updated, '%W, %M %D, %Y') AS updated

FROM some_table

That formats the date like this: Saturday, April 13, 2013.