srikotesh
asked on
How to get current date time in millinseconds using oracle
Hi Experts,
How to get CURRENT DATE TIME IN MILLISECONDS.
How to get CURRENT DATE TIME IN MILLISECONDS.
systimestamp:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SYSTIMESTAMP.html#GUID-FCED18CE-A875-4D5D-9178-3DE4FA956516
current_timestamp:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CURRENT_TIMESTAMP.html#GUID-CBD42B84-869D-45C7-9FFC-001DD7712097
localtimestamp:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/LOCALTIMESTAMP.html#GUID-3C3D1F29-5F53-41F2-B2D6-A3767DFB22CA
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/SYSTIMESTAMP.html#GUID-FCED18CE-A875-4D5D-9178-3DE4FA956516
current_timestamp:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CURRENT_TIMESTAMP.html#GUID-CBD42B84-869D-45C7-9FFC-001DD7712097
localtimestamp:
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/LOCALTIMESTAMP.html#GUID-3C3D1F29-5F53-41F2-B2D6-A3767DFB22CA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
There are tons of possible ways to solve this one ;-)
https://stackoverflow.com/questions/12105691/convert-timestamp-datatype-into-unix-timestamp-oracle
https://stackoverflow.com/questions/12105691/convert-timestamp-datatype-into-unix-timestamp-oracle
ASKER
thanks
There there are also options to include timezones.