I need a Sql query whhere for s Specific Date it should show me the Hour we have.
Example
if the Date is Today i.e. 31-JULY-2018 and Time when we are running the query is 10:20:30
it will give output as
-------------------------------
31-JUL-2018 00
31-JUL-2018 01
31-JUL-2018 02
31-JUL-2018 03
.
.
.
31-JUL-2018 10
if the date is Yesterday 30-JULY-2018
--------------------------------
30-JUL-2018 00
30-JUL-2018 01
30-JUL-2018 02
30-JUL-2018 03
.
.
.
30-JUL-2018 23