"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        (alexander AT sara DOT nl)
Alexander Verkooijen        (alexander AT sara DOT nl)
Senior Systems Programmer
SARA High Performance Computing