Hi to all Try to run a select query on the actlog table for certain msgno in certain period but got wrong result. Here my select command: select nodename , msgno , substr(message,44,14) as "Message " from actlog where (msgno=4961 or msgno=4964) and date_time=CURRENT_TIMESTAMP - 1 days
Without the date_time parameter I got what I want but for the entire period I need to limit my query for the last 24 hours. Please advise if possible .......... Regards Robert Ouzen E-mail: [EMAIL PROTECTED]
