Oct 24, 2014 05:31 PM|comego|LINK
I have a field in datetime formate like this: 2014/8/29 10:53:00
I want to list records in August, I have the following:
select count (*) as howmany from tally where (datepart(mm, submitTime = '8')
But I want to further specify the hour within 10 am. What would the sql be like?