ssage-
From: Gene Walters [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 25, 2001 11:45 AM
To: [EMAIL PROTECTED]
Subject: Re: ADSM/DATE/SQL
Try this:
SELECT NODE_NAME, PWSET_TIME from NODES where PWSET_TIME < CURRENT_TIMESTAMP
- 100 DAYS
>>> "Sheets, Jerald" <[EMAI
Try this:
SELECT NODE_NAME, PWSET_TIME from NODES where PWSET_TIME < CURRENT_TIMESTAMP - 100 DAYS
>>> "Sheets, Jerald" <[EMAIL PROTECTED]> 06/25/01 11:05AM >>>
Ladies and Gentlemen,
Do any of you out there have links to a SQL reference for ADSM ( I
already have the documentation from t
L PROTECTED]> on 25/06/2001 17:05:01
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:(bcc: Xavier 1 Chavanet/979460/Chalon/France/Europe/EKC)
Subject: ADSM/DATE/SQL
Ladies and Gentlemen,
Do any of you out there have li
"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)-day
Ladies and Gentlemen,
Do any of you out there have links to a SQL reference for ADSM ( I
already have the documentation from the Administrator's guide) or a SQL
92/93 reference? I am interested specifically with doing date calculations
using fields from DB, BACKUPS, and FILESPACES and N
