Cut and Paste date_format strings for MySQL
Normal MySQL date is formatted as 2007-4-12 but we need to have a way to format the date in a More readable format in the US so the chart below shows how to reformat the dates to suit US and UK standards... date_format is a MYSQL function can be used in INSERTS, UPDATES and SELECTS The date must be in MySQL Syntax 2006-01-02 for this Function to work properly!
select date_format(date, '%a %D
%b %Y') as formatted_date from table_name
UPDATE tableName
SET FIELDNAME = date_format('%d/%e/%Y')
Where date is
the name of your date field, and formatted_date
is a variable name which you can use to retrieve the value.
