sql - How to get data between two dates with timespan in c#? -

i want export data excel database, in excel want data timespan of minutes or hours.

so taking hours , minutes 2 separate comboboxes , selecting datetime 2 datetime pickers. , data minute minute.so want data 5 minutes time span?

data this:

i want data 4:32:44 4:38:45 1 minutes gap means

4:32:44 4:33:44 4:34:44 

so how can this:

you can use between keyword search values between 2 values:

the between operator used select values within range.

here example snippet might help:

select id, somecolumn mytable somecolumn between @date1 , @date2