All geek questions in one place

Select all rows with “Now minus 30 minutes” in Oracle SQL (11g)

How to express “now minus 30 minutes” in Oracle SQL WHERE so that I can compare it with a saved timestamp?

+4
source share
2 answers

The solution is either the dateadd() function, or

 systimestamp - INTERVAL '30' minute(1)
+10
source 
 where yourTimestamp >= sysdate - 1/48
+8
source

Source: https://habr.com/ru/post/1386558/

More articles:


All Articles