Oracle: how to add minutes to a timestamp?

by

In addition to being able to add a number of days to a date, you can use interval data types assuming you are on Oracle 9i or later, which can be somewhat easier to read,

SQL> ed
Wrote file afiedt.buf
SELECT sysdate, sysdate + interval '30' minute FROM dual
SQL> /

SYSDATE              SYSDATE+INTERVAL'30'
-------------------- --------------------
02-NOV-2008 16:21:40 02-NOV-2008 16:51:40

More Related Contents:

  1. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  2. How are dates stored in Oracle?
  3. Calculate difference between 2 date / times in Oracle SQL
  4. Using date in a check constraint, Oracle
  5. Formatting DATE in oracle
  6. How to find difference b/w TIMESTAMP format values in Oracle?
  7. Convert epoch to date in sqlplus / Oracle
  8. Valid Date Checks in Oracle
  9. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  10. Get the number of days between two dates in Oracle, inclusive of the dates
  11. How to get the week day name from a date?
  12. Oracle Convert TIMESTAMP with Timezone to DATE
  13. Printing the value of a variable in SQL Developer
  14. Add a month to a Date [duplicate]
  15. null vs empty string in Oracle [duplicate]
  16. Convert comma separated string to array in PL/SQL
  17. UTL_FILE.FOPEN() procedure not accepting path for directory?
  18. Oracle stored procedure with parameters for IN clause
  19. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  20. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  21. Oracle: How to find out if there is a transaction pending?
  22. Best practice for pagination in Oracle?
  23. Sql*plus always returns exit code 0?
  24. How to find out when an Oracle table was updated the last time
  25. NLS_LANG setting for JDBC thin driver?
  26. Is it possible to kill a single query in oracle without killing the session?
  27. Get the LENGTH of a LONG RAW
  28. Reading clob line by line with pl\sql
  29. How to Register Pluggable Database(PDB) with new created LISTENER
  30. ORA-12704: character set mismatch

Leave a Comment