Try this: select node_name, reg_time from nodes where cast((current_timestamp-reg_time)days as decimal)>30 -- Warm regards, Michael Green
On Thu, Feb 11, 2010 at 6:46 PM, Richard Rhodes <rrho...@firstenergycorp.com> wrote: > > 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.