Question from a sql newbie using TSM 3.7.2

The following works (activity log of previous day):

select * from adsm.actlog where -
(cast((current_timestamp-date_time)day as -
decimal(18,0))=0)


The following NOT (events from previous day):

select * from events where -
(cast((current_timestamp-scheduled_start)day as -
decimal(18,0))=0)

This only gives events of the current day ?????

WHY ? and how to make it work ??

Anyone having the answer(s) ????

Tnx in advance

Xavier Merlin