i have a time format that i want to insert into a mysql database.
the format it
4/3/2012 9:54:03 AM
what type can i set the column to be for this format to work ?
You probably want the TIMESTAMP format. Do not let the fact that the dates are stored in ISO format YYYY-MM-DD disturb you or prevent you from selecting this format. When the date is retrieved from the database, your web (or other) application will reconvert it to the syntax for your local system.