Hi,
I'm just reading about the 'as of' timestamp query in oracle.
What i'd like to be able to do is say select * from table1 for a specific time and date ie 15:15.
I can do it at the moment for things like sysdate -1/24, or similar, but i'm unsure how i'd do this query for a specific time of day?
Is there a way of doing this?
Thank you!