select node_name, date(lastacc_time) as "LAST ACCESS", -
 current date - date(lastacc_time) as "DAYS SINCE" -
 from nodes where (days(current date) - days(lastacc_time)) < 30

Reply via email to