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 Link to comment https://forums.phpfreaks.com/topic/125984-date-change/ 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 Link to comment https://forums.phpfreaks.com/topic/125984-date-change/#findComment-651496 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. Link to comment https://forums.phpfreaks.com/topic/125984-date-change/#findComment-651531 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 Link to comment https://forums.phpfreaks.com/topic/125984-date-change/#findComment-651642 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.