0

I am using SQL developer to run queries on a database and one of the tables shows a create date for each request added. The query pulls a unix time stamp back and I haven't had much luck on Google when searching for Oracle SQL Dev.

select ID, CREATED
from REQUESTS
where ID = 'bob'
order by create_date DESC;
Dale K
  • 25,246
  • 15
  • 42
  • 71
user3663785
  • 11
  • 4
  • 1
    And you tag SQL Server for what reason? And you did NOT tag Oracle for what reason? – SMor Feb 23 '21 at 23:25
  • 1
    Does this answer your question? [oracle convert unix epoch time to date](https://stackoverflow.com/questions/37305135/oracle-convert-unix-epoch-time-to-date) – SMor Feb 23 '21 at 23:26
  • Chill bruh - Thanks ill check it out – user3663785 Feb 23 '21 at 23:30
  • What format is your Unix “time stamp”? Number of string? And what does it look like? As an aside, is the column in ORDER BY the same as in SELECT? It doesn’t look like it. –  Feb 24 '21 at 01:07
  • It would help to show example of these timestamp values, no? – OldProgrammer Feb 24 '21 at 03:18

0 Answers0