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...

What Sean says.

It'll be much easier to suggest which to use if you can give us some sample data and tell us what you want to do with it.

That really depends on what you're trying to achieve. Both could be correct (or incorrect).

Hide

Which answer are you getting the error on?

SELECT

SampleDate,

CAST(SampleDate AS time),

SampleID

FROM

DateTimeQuery

WHERE

CAST(SampleDate AS time) >= dateadd(hh, datediff(hh, 0, getdate()) - 1, 0)

AND

CAST(SampleDate AS time) < dateadd(hh, datediff(hh, 0, getdate()), 0)

That will return the data...