Hi all,
These 2 scripts give back different results:
With timestamp:
With date:
How could I get the timestamp one to work?
It's like it doesn't go back after midnight.
These 2 scripts give back different results:
With timestamp:
Code:
select distinct events.node_name, events.status, nodes.platform_name from events, nodes where events.node_name=nodes.node_name and events.status<>'Completed'
and events.status<>'Future' and events.scheduled_start>current_timestamp-1 day
With date:
Code:
select distinct events.node_name, events.status, nodes.platform_name from events, nodes where events.node_name=nodes.node_name and events.status<>'Completed'
and events.status<>'Future' and events.scheduled_start>'2012-03-28'
How could I get the timestamp one to work?
It's like it doesn't go back after midnight.