sql select events previous day fails?
2001-01-18 05:37:35
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- sql select events previous day fails?,
Xavier Merlin <=
|
|
|