How can I select data from MySQL based on date (unix time record)

Question

I have a data record with a unix time date in it

I want to select a row based on date / month / year only (not with time)

I am currently using something like this

select * 
  from tablename 
 where date > '$today' 
   and date < '$tomorow' 
 LIMIT 1;

no matter how accurate it would be if $ today and $ tomorrow have different times (but at the same time)

Is there a better way to do this?

+2

bbnn May 17 '10 at 23:54

2 answers

Use this statement:

 SELECT * FROM TABLE WHERE DATE LIKE 'YEAR-MOTH-DATE%'.

For example, I use this for my case:

 SELECT * FROM USER_MANAGER u WHERE DATE_REGISTER LIKE '2012-09-08%';

0

daz 29 oct. 12 at 18:45

Amber · Accepted Answer · 2010-05-17T23:58:38+0000

... WHERE DATE(FROM_UNIXTIME(date)) > DATE(FROM_UNIXTIME('$today')) ...