Arsench Posted September 26, 2008 Share Posted September 26, 2008 Hello, please help me to change the mysql date, its a 0000-00-00 but I want to change to dd-mm-yyyy. Thank you very much Quote Link to comment Share on other sites More sharing options...
Alkimuz Posted September 26, 2008 Share Posted September 26, 2008 you can chance the date out of your database to any form you like with the function: DATE_FORMAT in your case: $result = mysql_query("SELECT date, DATE_FORMAT(date, '%d-%m-%Y ') as date FROM table" ) take a look at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format Quote Link to comment Share on other sites More sharing options...
discomatt Posted September 26, 2008 Share Posted September 26, 2008 you can chance the date out of your database to any form you like with the function: DATE_FORMAT in your case: $result = mysql_query("SELECT date, DATE_FORMAT(date, '%d-%m-%Y ') as date FROM table" ) take a look at http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format You should be able to use $result = mysql_query("SELECT DATE_FORMAT(date, '%d-%m-%Y ') as date FROM table" ) No need for the initial date column. Quote Link to comment Share on other sites More sharing options...
Arsench Posted September 27, 2008 Author Share Posted September 27, 2008 Thank you friends, the problem is, when Im inserting from the date_field into my db, if Im using dd/mm/yyyy its insert this only even doesnt insert the numbers 0000-00-00,is there any secction to change before inserting date? thanks agaain Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.