Oracle Time Request

Question

Query:

SELECT col1 
  FROM table1 
 WHERE TRUNC(created_date) = TRUNC(sysdate) 

If the request completed 10 minutes and the request was launched @ 11.55 PM - What will be the result of the request? Will the request return data created_datewhen sending the request or when receiving the result, or depending on any other factor?

Answer 1

You will receive data on the date the request was sent in this case.