Skip to main content
A
AdrianLe
Known Participant
April 12, 2013
Question

No date formatting options in DW for PHP?

  • April 12, 2013
  • 1 reply
  • 489 views

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???

This topic has been closed for replies.

1 reply

David_Powers
David_Powers
Inspiring
April 13, 2013

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices