How do I do minute operation on the "date" data type?

[DixieFlatline]

Hi,<br><br>I am trying to write a script that takes a count of records that have been added in the past 30 minutes.&nbsp;&nbsp;Does anyone know how I can setup the date variable to 30 minutes before the current time?&nbsp;&nbsp;I tried using the minus operator on the date, but it seems to interpret my code as wanting to take 30 days off sysdate.&nbsp;&nbsp;Need help.&nbsp;&nbsp;Thank you.<br><br>Karl<br><A HREF="mailto:_karlk2@excite.com">_karlk2@excite.com</A>

 

[listener22]

&nbsp;&nbsp;&nbsp;&nbsp;Try (sysdate - (1/48)). <p>Jim<br><a href=mailto:nx56@inetarena.com>nx56@inetarena.com</a><br><a href= > </a><br>oracle, vb, some javascript

 

[DixieFlatline]

Thanks, I will give it a try.