[PL/SQL] How to convert date to Unix Timestamp

[PL/SQL] How to convert date to Unix Timestamp

Unix Timestamp describes the point in time as the number of seconds that have elapsed since 00:00:00 (UTC), Thursday, 1 January 1970. The simple function implemented in this post helps you to calculate Unix Timestamp in Oracle Database. It can be useful in many different cases; i.e. integration with Java.

Below is an example of Unix Timestamp. More about it you cam find here.

Date Unix Timestamp
2018-05-28 18:00:55 1527530455

 

How to calculate Unix Timestamp in PL/SQL

Oracle Database hasn’t implemented UUID function yet, but you can use the following function:

 

If you think this post is valuable, please leave me +1  or share it. This action will allow me to reach a wider audience.

Thank you.

 

Leave a Reply

avatar
  Subscribe  
Notify of
Close Menu