Convert epoch to date in sqlplus / Oracle

by

In Oracle, adding X to a DATE will return you a DATE X days later.

If ESTIMATEDENDTIME is milliseconds since Epoch then you could do

DATE '1970-01-01' + ( 1 / 24 / 60 / 60 / 1000) * ESTIMATEDENDTIME

and then use to_char to achieve the correct format of the resulting date. e.g:

SELECT 
  captureid
, startdate
, enddate
, state
, estimatedendtime
, DATE '1970-01-01' + ( 1 / 24 / 60 / 60 / 1000) * estimatedendtime AS estimatedenddate
FROM recording

More Related Contents:

  1. oracle convert unix epoch time to date
  2. How are dates stored in Oracle?
  3. Is java.sql.Timestamp timezone specific?
  4. Determining location of relevant tnsnames.ora file
  5. Using date in a check constraint, Oracle
  6. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  7. In Python, how do you convert seconds since epoch to a `datetime` object?
  8. Oracle: Import CSV file
  9. Convert a date format in epoch
  10. When or Why to use a “SET DEFINE OFF” in Oracle Database
  11. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  12. Formatting DATE in oracle
  13. Sql*plus always returns exit code 0?
  14. SQL*Plus how to accept text variable from prompt?
  15. Oracle Age calculation from Date of birth and Today
  16. Oracle: how to add minutes to a timestamp?
  17. Valid Date Checks in Oracle
  18. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  19. oracle SQL plus how to end command in SQL file?
  20. How to get the week day name from a date?
  21. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  22. How can I issue a single command from the command line through sql plus?
  23. How to View Oracle Stored Procedure using SQLPlus?
  24. Calculate difference between 2 date / times in Oracle SQL
  25. How to select date from datetime column?
  26. How can I parse dates and convert time zones in Perl?
  27. ways to avoid global temp tables in oracle
  28. In Ruby on Rails, what’s the difference between DateTime, Timestamp, Time and Date?
  29. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  30. Get ID of last inserted record in oracle db

Leave a Comment