hello friends,
i am using phpmyadmin the default date format for it is YYYY-MM-DD.
but i want to store dates as MM-DD-YYYY.
how can i accomplish it.
one way to use a text field but i donot want to use it like this
PLZ HELP ME it’s urgent
This has nothing to do with phpMyAdmin. This is the format of DATE columns in MySQL. There is absolutely no reason to store dates as ‘MM-DD-YYYY’ or any other format, as you can retrieve DATE column values in whatever format you want using the date functions in your SELECT query.
MySQL 5.0 Reference Manual :: 12.5 Date and Time Functions
MySQL 3.23, 4.0, 4.1 Reference Manual :: 12.5 Date and Time Functions