faqts : Computers : Databases : MySQL : Language and Syntax : Field Types : Date

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

3 of 6 people (50%) answered Yes
Recently 1 of 3 people (33%) answered Yes

Entry

How do i chage the dateformat "0000-00-00" (year-month-day) to "00-00-0000" (day-month-year)(my fieldname is "fdato" date)

Aug 29th, 2008 03:25
Tonmoy Tewary, Jan-Borge Landro,


you cant change it.
you have to store it in that format.
but at display time you can date fuction with different parameter to 
display in different format