using date functions with unix time

[Anon]

Hi,
I'm integrating my site with vbulletin bbs. They use unixtime to keep track of their time in fields formatted with int(10) .

How would i integrate time into my query?

for example.. normally i can use this query to select everything in a field dated today.

select * from table where day(time_field)=day(now())

with the "time_field" field formated as int(10) and in unixtime, i can not make this query work. is there any way to do this?

[Anon]

$start = date("U", mktime($h,$m,$s,$m,$d,$y));
$end = date("U", mktime($h,$m,$s,$m,$d,$y));

select * from table where intdate > $start and indate < $end;

I think that will work. If you are uning mysql, there is a unix_timestamp function you could probably use.