Changing the format of a date.

[wright67uk]

How can I change a date from YYYY-MM-DD to DD/MM/YYYY ?

 

I have a date picker in a form which always posts in this format: 2013-01-30

When I process the form I would like to store this date into a variable but in this format 30/01/2013.

 

So I need to replace dashes for slashes, and reverse the order of year, month, and date.

[Jessica]

No, you want to store the date the way it is. That's the proper format to store a date.

 

You can reformat it using date() when you want to display it, but store it in the ISO format.

[PFMaBiSmAd]

You need to store the date in a DATE data type with the YYYY-MM-DD format. The only time you should format as DD/MM/YYYY is when you want to display it.

 

edit: damn, the forum's post notification (or lack of) gets a -20 likes.

Edited January 6, 2013 by PFMaBiSmAd

[Barand]

edit: damn, the forum's post notification (or lack of) gets a -20 likes.

 

Only -20. How generous! Along with the "What You See Is Nothing Like What You Get" editor!

[PFMaBiSmAd]

Actually, the editor is a What You Shouldn't see Is What You Get.