Update Sysdate - 10 min in Oracle
oracle, sysdate
Solution
Like this probably
select sysdate - 10/(24*60) from dual;
Problem
I need to update a date column, with sysdate but 10 mins past. Is there any way to do? Please help.
oracle, sysdate
Like this probably
select sysdate - 10/(24*60) from dual;
I need to update a date column, with sysdate but 10 mins past. Is there any way to do? Please help.