Between two Date Range

Question

Hi all

 

my sql select query 

 

SELECT count(mrcpsession),mrcpsession,mrcptime,mrcpclient FROM ibot.mrcp where mrcptime between '2018-06-13 01:00:00' and '2018-06-13 02:00:00' group by mrcpsession;

 

when i run sql query out coming between date.

 

I need to know how we can select the data range with time frame i hours between two dates

MySqlCommand cmd = new MySqlCommand("select count(mrcpsession),mrcpsession, mrcptime, mrcpclient ibot.mrcp where mrcptime between @mrcptime1 and @mrcptime2 group by mrcpsession;", con);

cmd.Parameters.AddWithValue("@mrcptime1", First_date);

cmd.Parameters.AddWithValue("@mrcptime2", Secoundate);

DataSet dst = new DataSet();

MySqlDataAdapter dtr = new MySqlDataAdapter(cmd);

dtr.Fill(dst);

Console.WriteLine(dst);

Console.Read();

can you suggest code please i need to show console application when select data range

 

i should show console application when data range give