| Select with Time Range [message #643837] |
Mon, 19 October 2015 16:29  |
Duane
Messages: 591
Registered: December 2002
|
Senior Member |
|
|
I'm trying to figure out how to select rows based on a 5 minute window. Not sure if I should be using an EXTRACT statement or not.
CREATE TABLE BLACKBOARD_FINAL_GRADE
(
SEQUENCE NUMBER ,
CLASS_NBR INTEGER,
TERM VARCHAR2(6 BYTE),
EFFDT DATE DEFAULT sysdate
)
Insert into BLACKBOARD_FINAL_GRADE
(SEQUENCE, CLASS_NBR, TERM, EFFDT)
Values
(1, 40001, 'FS2015', TO_DATE('10/19/2015 14:56:27', 'MM/DD/YYYY HH24:MI:SS'));
Insert into BLACKBOARD_FINAL_GRADE
(SEQUENCE, CLASS_NBR, TERM, EFFDT)
Values
(2, 40002, 'FS2015', TO_DATE('10/19/2015 16:23:39', 'MM/DD/YYYY HH24:MI:SS'));
Insert into BLACKBOARD_FINAL_GRADE
(SEQUENCE, CLASS_NBR, TERM, EFFDT)
Values
(3, 30001, 'FS2015', TO_DATE('10/18/2015 16:24:05', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;
OUTPUT:
Only records for the current day within a 5 minute window of running the SELECT STATEMENT.
EXAMPLE:
select *
from BLACKBOARD_FINAL_GRADE
where trunc(sysdate) = trunc(effdt) and
effdt time is within 5 minutes of sysdate time
Any examples?
[Updated on: Mon, 19 October 2015 16:30] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
