Preeti Arora asked 1 year ago
Title : How Oracle DB function can be used to convert epoch timestamp to date. Please advise.

Question :

How Oracle DB function can be used to convert epoch timestamp to date. Please advise.

1 Answers
Umesh SharmaUmesh Sharma Staff answered 1 year ago

You may create function in sql developer that takes input in the form of epoch, then checks whether the date lies in DST timezone or not. If it lies in DST timezone, add one hour to it. The output will be returned in desired readable format, For example : DD-MM-YY,etc

Cubastion is among a very small number of specialized Siebel CRM Oracle Gold Partners in SME.