search for date unix time mysql query

[ade234uk]

I am trying to work out how to search items that where sold on a specific date in the database by using a mysql query.

The items have a unixtime for example 1211746428 of when they where sold.

Using an online convertor 1211746428 = Sun, 25 May 2008 20:13:48 GMT

How could I query the database to find items that where sold on the 25/06/08 and covert the unixtime to a date which would allow me to search for other dates?

Thank you

[NogDog]

One possibility: use the MySQL FROM_UNIXTIME() function to convert the column to a date string, and compare it to the desired date (using the same date string format).

SELECT *, FROM_UNIXTIME(date_column, '%Y-$m-$d') AS date_str WHERE date_str = '2008-06-24'

[ade234uk]

Brilliant I will give this a go tommorow. I have been scratching my head for hours on how I do this.