I've tried everything so any help would be appreciated.
I've got a db field (ts) that contains the value for Time(). I need to select records where ts is equal to the current date.
I've tried using TO_DAYS(NOW()) - TO_DAYS(TS) < 1 but that returns nothing.
I've tried floor((time() - ts)/86400) < 1 but that brings back the last 2 days.
If it helps I running MySQL 3.23.36 on WinNT under IIS.
Ned
