Time Question [message #37206] |
Thu, 24 January 2002 09:18 |
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 |
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.
|
|
|