Change date format (in DB or output) to dd/mm/yyyy - PHP MySQL

Posted by Jess on Stack Overflow See other posts from Stack Overflow or by Jess
Published on 2010-03-19T19:53:30Z Indexed on 2010/03/19 20:01 UTC
Read the original article Hit count: 247

Filed under:
|
|
|

MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ?

I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about php