"Sheets, Jerald" wrote:
> So then, to acheive the above desired result, what would my syntax be to
> select all the node_name(s) and PW_SET dates older than 100 days?
I use the DAYS function for this kind
of queries.
Here is an example:
select node_name as "Node Name", \
days(current_date)-days(lastacc_time) as "Last access (>10)" \
from nodes \
where (days(lastacc_time) < (days(current_date)-10))
Hope this helps,
Alexander
--
-----------------------------------------------
Alexander Verkooijen ([EMAIL PROTECTED])
Senior Systems Programmer
SARA High Performance Computing
