Date format in MySQL

Mike's Avatar
Go4Expert Member
In mySql DB date is stored as a yyyy-mm-dd but i want to show it as dd-mm-yyyy.
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Use of SQL's prime reason is whatever you store is independent of what you can retrieve (format). That is view can be changed to whaterver format we wish to get from the stored data.

Now when you store the date its like yyyy-mm-dd and now to retrieve in dd-mm-yyyy you can just use the following SQL so that you dont need to do anything fancy in PHP

PHP Code:
$sql "SELECT DATE_FORMAT(date_column_name, '%d-%m-%Y') AS new_date FROM table_name WHERE...."
Also you can see the complete Description of DATE_FORMAT function here http://dev.mysql.com/doc/mysql/en/da...functions.html
Mike's Avatar
Go4Expert Member
Thaks
Mike's Avatar
Go4Expert Member
OOPs Type error. Thanks.