Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Query to get current day midnight epoch value

Pratap DalaiNov 22 2019 — edited Nov 24 2019

HI All,

Please let me know how to get the midnight epoch value of the current date

for example if the run the query, i should get the epoch value like 1574380800 (which is equivalent Friday, November 22, 2019 0:00:00 )

Thank You,

Pratap

This post has been answered by mathguy on Nov 22 2019
Jump to Answer
Comments
Post Details
Added on Nov 22 2019
8 comments
1,576 views