moon-buddy
ADSM.ORG Moderator
Does someone know the right syntax for this? Tried other variations.
Trying:
select node_name from events where status='Failed' and (scheduled_start>({'2018-06-02 08:00:00'}-1 day) and scheduled_start<('2018-06-02 08:00:00'))
to get failed backups between the two dates of 2108-06-01 and 2018-06-02.
Fails on the date structure: An expression with a datetime value or a labeled duration is not valid.
Trying:
select node_name from events where status='Failed' and (scheduled_start>({'2018-06-02 08:00:00'}-1 day) and scheduled_start<('2018-06-02 08:00:00'))
to get failed backups between the two dates of 2108-06-01 and 2018-06-02.
Fails on the date structure: An expression with a datetime value or a labeled duration is not valid.