Assuming user enters the input report run date as @ReportDate and you need to generate the report for previous month and previous quarter, below is how I have calculated the...

Lynn, the intention of the author when executed as a batch was totally lost by mentioning

"....same date hour, minute and second?"

It is not even like looking at the half filled...

Lynn Pettis (11/20/2009)

---

aaz (11/20/2009)

---

>>Will all these statements (...) return an equivalent date, hour, minute and second <<

Actually it did, if you take into account the time zones, and adjust appropriately;...

Lynn Pettis (11/18/2009)

How do you compare the results if you don't have an understanding of how they are generated? To compare something, you have to understand (know, comprehend) what...

Lynn Pettis (11/18/2009)

---

rparakalla (11/18/2009)

---

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and getutcdate()...

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and getutcdate() is different. getutcdate...

If you really consider the practical purpose of getdate() & getutcdate(). One would either use Getdate() or getutcdate(). But not both in the same table for audit purpose. For this...

I did catch the difference. But thought we are not going anywhere by these discussions.

Most of the questions posted in QOD is to answer the question and not the intentions of the person who writes the question I guess

I totally agree with you! When the question says "date", "hour" & "seconds" in particular, the answer is false in true sense.

I also answered right as False.

Yup, I tried that EDIT/// button and that is how I ended up with this mess 🙁 !

It took lot of time for formatting the sample 3 line summary data. I tried to delete/edit the post (from original content) but I couldn't find such an option in...

It took lot of time for formatting the sample 3 line summary data. I tried to delete/edit the post (from original content) but I couldn't find such an option in...