Topic: MySQL + Date + php

[Canuck]

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

[ober]

I'm not sure why you're storing it as a varchar... you should be storing it as a date/time or whatever date format the database provides.

But yeah, the best way is to store it in that manner and convert it into seconds on the fly for display.

My method:

Code: [Select]

// $updated is an extract()-ed variable from a recordset