I have a table called CallsLogged with a column called EnteredOn.
The data in this column is a date in unix Time Stamp format.
I need to write a SQL query to retrieve all entries where the value of "EnteredOn" is Today.
At the minute the query looks like this:
WHERE EnteredOn BETWEEN DATEDIFF(Second, '19700101', DATEADD
(Day, DATEDIFF(Day, 0, CURRENT_TIMESTAMP), 0)) AND DATEDIFF
(Second, '19700101', DATEADD(Day, DATEDIFF(Day, 0, CURRENT_TIMESTAMP)+1, 0)) -1
This works great on a SQL Server Database but I need it to work on an Oracle Database.
I am getting the error 'DATEDIFF: invalid identifier'
Can anyone help translate this code into an oracle SQL query