From dd-mm-yyyy TO yyyy-mm-dd On INSERT

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

Guest
You could use it to specify the format:
DATE_FORMAT
http://www.phpfreaks.com/mysqlref/3.php
 
Well,
you can't format the input of the DATE column type :(
but you could format the output using
Code: 
DATE_FORMAT(date,format)
Also, as you suggested you can save it in the database as varchar and then give it the format.

bye!
 
You must log in or register to reply here.
Back
Top