data between 2 date ranges and time range

Mar 9 2020 5:49 AM

Hi im tying to find a solutions for my project which is a restaurnat based

i need to get the data between 2 date range and and with in 2 time range also

i need to query find a sales details between 2020-01-01 and 2020-01-31

and time in between 22:00 and next day 02:00

im am using sql server 2008 and visual studio 2017

can someone help

Answers (5)

How can i fix this issue on my query?