so I want all the nodes that hasn't been access for over 30 days.
This work if I run it today.
Select node_name,lastacc_time from nodes where lastacc_time < '2018-2-06'
what would I have to replace '2018-12-11' with to make it work?
I'd tried:
Select node_name,lastacc_time from nodes where lastacc_time=(current _timestamp-30 days)
Select node_name,lastacc_time from nodes where lastacc_time= date(current_date)-date)>30
Select node_name,lastacc_time from nodes where lastacc_time= NO W( ) - INTERVAL 30 DAY
This work if I run it today.
Select node_name,lastacc_time from nodes where lastacc_time < '2018-2-06'
what would I have to replace '2018-12-11' with to make it work?
I'd tried:
Select node_name,lastacc_time from nodes where lastacc_time=(current _timestamp-30 days)
Select node_name,lastacc_time from nodes where lastacc_time= date(current_date)-date)>30
Select node_name,lastacc_time from nodes where lastacc_time= NO W( ) - INTERVAL 30 DAY