Help on select syntax
2003-07-21 06:29:52
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: rouzen AT univ.haifa.ac DOT il
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Help on select syntax,
Robert Ouzen <=
|
|
|