i have a field in the database that is int(10). it is a date field, but in unix time.
i need to query mysql for all entries from today:
normally i'd do:
select * from table where day(date)=day(now())
i don't know how to do this however if the date field is an int(11) and unix time.
normally i'd re-design the table, but it is a forum table that i can not disturb.
Please let me know if it's possible to do this.
thanks
-mike
