I'm using Form Toolkit's datepicker to choose and insert a date into a MySQL database for an event registration section of a site. Once inserted (or updated), the date is displayed on a DataAssist results page in a backend admin section as well as on a front end Event Listing page.
In short, is there a way to store the dates in the format that MySQL needs (yyyy-mm-dd), but then display them in U.S. format (mm/dd/yy) on the site pages?
Reading through the forums I came across a lot of useful tips, but I don't think I came across what I need. At first I had the table row set to Date and used the strtotime() and date() functions, to format the date properly for the database, but then I get this same format appearing on the webpages. I also tried setting the row to varchar, but the problem is 1/1/2012 appears before 11/1/2011. I set up my DataAssist Results page to sort by date in ascending order.
I did some Google searches and came across some things in the MySQL documentation about changing date formats, but I wasn't sure if this is the direction I should be going. I'd appreciate any help. If I haven't provided enough info., please let me know. Thanks.