ADSM-L

Select Statements - Three questions (bugs?) so far

1998-11-10 10:02:04
Subject: Select Statements - Three questions (bugs?) so far
From: "Brazner, Bob" <Bob.Brazner AT JCI DOT COM>
Date: Tue, 10 Nov 1998 09:02:04 -0600
Eric,

I have had no trouble using the command syntax shown in the V3
Administrator's Reference for the SELECT command.  Example:
SELECT ... WHERE CAST((CURRENT_TIMESTAMP - BACKUP_END)DAYS AS DECIMAL)>30
In your case, if you need special code to test for a null time, you could
add:
... AND BACKUP_END IS NOT NULL
You're correct about the little redirection problem.

Bob Brazner
<Prev in Thread] Current Thread [Next in Thread>
  • Select Statements - Three questions (bugs?) so far, Brazner, Bob <=