Please suggest a oracle query between two dates and timing should be between 8 Pm(April1) to 5AM(April2) and group by should come dates..
I have selected based on dates... But timings I could not...need suggestion..
Select datecolumn1,column2 from table where trunc(datecolumn2) between '09-jan-2019' and 12-feb-2019' group by datecolumn1
Timing of the rows should be between 8pm to 5am .. how I should add where condition for this