Home:ALL Converter>What would the equivalent query be in oracle?

What would the equivalent query be in oracle?

Ask Time:2019-06-27T05:53:54         Author:Joe

Json Formatter

I am starting to use PL/SQL and to know how to use DATEDIFF, DATEADD

select DATEADD(HH, 1, DATEADD(dd, DATEDIFF(dd,0, GETDATE()),0))

What would the equivalent query be in oracle

Author:Joe,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/56781414/what-would-the-equivalent-query-be-in-oracle
yy