grappy Posted March 2, 2007 Share Posted March 2, 2007 changing the date format using phpmyadmin on a sql database, atm its 0000-00-00 which is american format i believe, and i want it to uk format which should be 00-00-0000, any1 know how? Link to comment Share on other sites More sharing options...
vijay Posted March 2, 2007 Share Posted March 2, 2007 Hi..use..SELECT DATE_FORMAT( '2007-01-31', '%m-%d-%Y' ) AS datesuppose this will help u..Regards,Vijay Link to comment Share on other sites More sharing options...
pulpfiction Posted March 2, 2007 Share Posted March 2, 2007 Little more information, look for "DATE_FORMAT" in page below....http://dev.mysql.com/doc/refman/5.0/en/dat...-functions.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now