Jeff Moden (3/1/2013)
ScottPletcher (3/1/2013)
C'mon, be real, that code is clear enough that a decent developer will understand what it means. Anyone who's developed for SQL for any period of time understands that SQL's base date is 1900.Since you've worked for a company with "hundreds of developers", I'm genuinely surprise by your "be real" comment. You'll find many so called "decent" developers that get hired into a company of that size that don't even know what DATEADD is never mind that 1900 is the base date for an underlying serial number.
That's a self-contradictory claim. By definition, a decent T-SQL developer would know what DATEADD is. A decent developer that develops professionally with TSQL for a period of time would at least know that DATEADD is.
Int'l Paper was a $25B+ company at the time, with over 100,000 employees (I think they're down to 70K now). If you want to imply that a company that size would not have "hundreds of developers", that's your choice. I won't bother with FedEx, as I assume you'll make the same unsupported "asnides" about them as well. As for myself, I won't imply that people are liars w/o some actual evidence.
Patently silly claims, otoh, can easily be identified a priori as false.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.