If your dates are stored as

2014-09-26 14:25:51.310

2014-09-26 12:46:42.647

2014-09-24 14:49:35.190

2014-09-24...

Good spot Chris. I'd mentally accounted for it but forgot to actually write it in.

create table #Test

(

CreatedOn datetime

,ID int identity(1,1)

)

insert into #test

select '2014-09-26 14:25:51.310' union all

select '2014-09-26 12:46:42.647' union all

select '2014-09-24 14:49:35.190' union all

select '2014-09-24 12:39:21.150' union all

select '2014-09-19 15:22:36.233' union all

select '2014-09-19...

I'm struggling to understand what you need. Is that the only row you need returning? Can you post some sample data please.

What exactly is the problem? You need to be very careful using BETWEEN with datetime. You're much better using >= and <=.

Lynn Pettis (9/25/2014)

---

Sean Lange (9/25/2014)

---

Between the spammers and crussell commenting on every single QOTD from the last 8 years there is next to nothing going on around here lately. I...

Hi Bill,

thanks for the Series. I've struggling with an odd problem with comparing the results in Excel. When I copy the filtered results across and apply the Auto-Average...

Colon

Ouroboros

Bite

If you change the fixed date to getdate() or the time you ran the report it will round the hour to the start of that hour for the start date...

StartDate = dateadd(hh, datediff(hh, 0, '2014-09-24 08:30:00.000') - 1, 0)

EndDate = dateadd(hh, datediff(hh, 0, '2014-09-24 08:30:00.000'), 0)

Does that do what you want?

Hi Jagadeesh,

welcome to the forum. I'm not sure what your question is there. If you read the article in my signature it will make it much easier to...

Do you mean how do you show a rounded time in the end date column?

I looked at the question and thought that was a lot to do for first thing in the morning. Then I looked at it again and saw what the...