Home » SQL & PL/SQL » SQL & PL/SQL » Time Question
Time Question [message #37206] Thu, 24 January 2002 09:18 Go to next message
Lance Pris
Messages: 40
Registered: January 2002
Member
I am not sure how to ask this or if it is even possible. I have a stored procedure that runs every five minutes and writes the data to a table. I want to query every thirty minutes and group the rows from the last half our.

would I used date difference?

Thank you in advance
lance
Re: Time Question [message #37209 is a reply to message #37206] Thu, 24 January 2002 09:52 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Yes, you need a date&time column (datatype DATE populated with sysdate when you create each record). Just query where MY_DATE_FIELD > sysdate - 1/24/2.
Previous Topic: How do I query a VARCHAR2 using hex notation ?
Next Topic: Using a procedure
Goto Forum:
  


Current Time: Sat May 30 11:13:36 CDT 2020