MySQL date_format

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.

Example Date: 1st April 2005
date_format String	Example
	1/4/2005 UK
	4/1/2005 US
	01/04/2005 UK
	04/01/2005 US
	1/4/2005 12:30 UK
	4/1/2005 12:30 US
	01/04/2005 12:30 UK
	04/01/2005 12:30 US
	1/4/2005 12:30:10 UK
	4/1/2005 12:30:10 US
	01/04/2005 12:30:10 UK
	04/01/2005 12:30:10 US
	Fri 1st Apr 2005
	Fri 1st Apr 2005 12:30
	Fri 1st Apr 2005 12:30:10
	Fri Apr 1 2005
	Fri Apr 1 2005 12:30
	Fri Apr 1 2005 12:30:10
	Friday 1st April 2005
	Friday 1st April 2005 12:30
	Friday 1st April 2005 12:30:10