That definitely looks wrong. I'll take a closer look later today. – Aaron Bertrand♦Jul 27 at 11:56
2
Presumably you were answering the part of the question Is there any tool that could find the objects using the date and time? – Martin SmithJul 27 at 17:10
1
If it's a bug in the database, it's quite ironic that it's on DBA.SE. :) – Matt JohnsonJul 27 at 17:18
@MartinSmith that is what I thought when I looked at it but just wanted to make sure, and I guess most may look at his first question. – Shawn MeltonJul 27 at 17:27
Actually yeah it makes sense now after re-reading a couple of times, though the answer should explicitly call out "commands that use a local time zone, like GETDATE and CURRENT_TIMESTAMP." I'll edit that in (and if you don't like it you can roll it back :-)). – Aaron Bertrand♦Jul 27 at 20:25
@AaronBertrand looks good to me, thanks. – Shawn MeltonJul 28 at 3:25
Is there any tool that could find the objects using the date and time?
– Martin Smith Jul 27 at 17:10GETDATE
andCURRENT_TIMESTAMP
." I'll edit that in (and if you don't like it you can roll it back :-)). – Aaron Bertrand♦ Jul 27 at 20:25