top of page

How to add minutes to SYSDATE

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 7, 2024
  • 1 min read

Updated: Nov 13, 2024

SELECT sysdate                                   now,
       sysdate + interval '30' minute            next,
       sysdate + NUMTODSINTERVAL(30, 'MINUTE')   next2
FROM dual;

ree

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page