ryanthames/ms_conversion.sql

Created October 28, 2020 13:28

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ryanthames/aa68b1473e5a9db3159e7fe0da7ea5e8.js"></script>
Save ryanthames/aa68b1473e5a9db3159e7fe0da7ea5e8 to your computer and use it in GitHub Desktop.

Download ZIP

Convert milliseconds to timestamp in oracle

Raw

ms_conversion.sql

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment