I have a sql statement list below where I am selecting from a table converting the date to truncate the time. and retrive the data for today, Now I need to be able to run this select for the current day and also the the prvious 2 days. I would expect that the getdate funtion -2 would be the answer but i am getting spurattic results. Please advice
WHERE JobReleasedDt >= Convert(datetime, Convert(varchar, Getdate(), 101))
Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.