What's the best way to write a date check like this? I'm looking for any nodes registered after some number of days (the 30 is just an example).
dsmadmc -se=$i -id=$adminid -password=$adminpwd -tab -noc <<EOD select node_name, reg_time from nodes where reg_time \> 30 days EOD ANR2916E The SQL data types TIMESTAMP and INTERVAL DAY(9) are incompatible for operator '>'. | .....................................................V........ select node_name, reg_time from nodes where reg_time > 30 days Thanks Rick ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.