Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Select all Rows with "Now minus 30 minutes" in Oracle SQL (11g)

Tags:

sql

timestamp

oracle

oracle11g

How do I express "now minus 30 minutes" in an Oracle SQL WHERE, so that I can compare it with a stored timestamp?

like image 914
erikbstack Avatar asked Dec 15 '11 16:12

erikbstack

2 Answers

The solution is either the dateadd() function or

systimestamp - INTERVAL '30' minute(1)
like image 92
Eric Avatar answered Oct 14 '22 20:10

Eric

 
where yourTimestamp >= sysdate - 1/48
like image 26
xbrady Avatar answered Oct 14 '22 19:10

xbrady
Sign in to Comment

Related questions

SQL Max parameters
How to select top N from a table
SQL if no rows are returned do this
How to multiply values using SQL
Query error for query containing a column named "order"
Saving Password with Md5
What does the SQL standard say about parentheses in SQL UNION/EXCEPT/INTERSECT statements?
Case Insensitive searches/queries
one table or many for many different but interacting events?
Can I include a non-aggregated Column in an aggregate function in SQL without putting it into a GROUP BY clause?
Rounding decimal in sql server
SQL query- Update if exists, insert otherwise
Passing Date from an HTML form to a servlet to an SQL database
SQL BETWEEN not working
Add or subtract time from datetime in SQL server
how To select fields from two tables
Display deleted rows T-SQL
SQL Query to Select the 'Next' record (similar to First or Top N)
MySQL multiple insert performance
how to prevent SQL Injection in a asp.net website

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!