Epoch Conversion in SELECT

[ameadows]

I have an orders table that is storing all order dates using the unix timestamp epoch number. I want to be able to do a sql statement in php that will let me show the orders for a certain month or for a date range.

How can I write a sql statement that will convert

select from orders where cdate = 'June';
or
select from orders where cdate > '2002-06-01 AND < '2002-06-30';

when the cdate is stored as an epoch number?

I have seen lots of epoch conversion tools, but nothing that let's me convert it on the fly in a SQL statement.

Thanks In Advance,

Andy

[Anon]

MySQL has the FROM_UNIXTIME function

http://www.mysql.com/doc/D/a/Date_and_time_functions.html