SQLserver query rows in between specific date

Question

how could i get row by filtering in between specific date...

in my table, i have thousand of rows about Ordered Food.

I want to check ordered food between June-01-2011 1:00:00PM to June-05-2011 6:00:00pm. how could i suppose to write t-sql code...

Alex Aza · Accepted Answer · 2011-06-09 03:50:08Z

2

 select *
 from MyTable
 where MyDate >= `2011-06-01T13:00:00` and  MyDate < '2011-06-05T18:00:00'

if you want to include both datetimes:

 select *
 from MyTable
 where MyDate between `2011-06-01T13:00:00` and  '2011-06-05T18:00:00'

answered Jun 9, 2011 at 3:50

Alex Aza

78.8k26 gold badges157 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NullRef · Accepted Answer · 2011-06-09 03:51:28Z

1

Making some wild assumption about your table structure basically do this...

Select * from ordered_food 
where ordered_date 
between '2011-06-01 13:00:00' and '2011-06-05 18:00:00'

answered Jun 9, 2011 at 3:51

NullRef

3,7381 gold badge22 silver badges18 bronze badges