converter.md

Bookmarks tagged [converter]

www.codever.land/bookmarks/t/converter

How to convert milliseconds to date string in Oracle SQL

^{http://www.asjava.com/oracle/how-to-convert-milliseconds-to-date-string-in-oracle-sql/}

select to_char(to_date('1970-01-01 00','yyyy-mm-dd hh24') +
(1126483200000)/1000/60/60/24 , 'YYYY-MM-DD HH12:MI:SS am') datestr from dual

where 1126483200000 is the time in milliseconds.

• tags: oracle, converter

---