Simple date arithmetic

As a product of MS SQL Server culture, I am at a significant loss when trying to do simple date arithmetic in Oracle 7.

For example, how do I shave off 30 minutes from SYSDATE?

This does not seems to work:

SELECT SYSDATE - TO_DATE(30,'MI') OUT FROM DUAL; Do I need to use a TO_CHAR() somewhere?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 27 2000 - 18:19:57 CDT