I have a db, and I realized today when I was sorting dates, stored in the db as a varchar, in the form of 2/27/2005, that they werent getting sorted properly.
I want to perform a query on the date to get the 20 most recent entries of the db according to the date received column.
I found the php function strtotime which converts the date into seconds. Is it best to convert the time into seconds using this function, store it in the db in that maner, and when I need to print the date I use strtotime again to format it properly?
Thanks