I have an old database that has a date column and time column in a table where the date format is year-month-day (2006-4-16) and time format is 12 hour with am or pm (8:30pm). The problem is that I can't sort the contents correctly by date and time. The date sort works fine, but not the time due to the format.
Any ideas how I can easily change the existing dates to a 24 hour format in the database?
Is it better to just have one column that stores both date and time together using mktime?
thanks!
