blew Posted February 13, 2011 Share Posted February 13, 2011 guys, im having a problem here... i tried too many ways to convert dates in american format, to brazilian format, but no one is working... how can i do that, to convert it to dd/mm/yyyy (it comes from my db in mysql)... Quote Link to comment https://forums.phpfreaks.com/topic/227558-converting-dates-yyyymmdd-to-ddmmyyyy-from-mysql/ Share on other sites More sharing options...
Pikachu2000 Posted February 13, 2011 Share Posted February 13, 2011 You can format the date in the query string and just alias it for easier access to the value. SELECT DATE_FORMAT(`date_field`, '%d-%m-%Y') AS `f_date` Quote Link to comment https://forums.phpfreaks.com/topic/227558-converting-dates-yyyymmdd-to-ddmmyyyy-from-mysql/#findComment-1173784 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.