Hi,

I need to substract a few seconds from the sysdate. I am using the sysdate in a 'where' clause. I know, I can substract days straight as follows
select (sysdate-1) from dual.

Please let me know your feedback.

Thanks,
Ramesh