Select between timings

Posted by Oswaldlily under Oracle on 6/8/2019 | Points: 10 | Views : 1830 | Status : [Member] | Replies : 0
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


(No response found.)

Login to post response