http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/08/my-datetime-faq.aspxI am rising to Adam's challenge for his very first T-SQL Tuesday , and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forwardenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/08/my-datetime-faq.aspx#19710Wed, 09 Dec 2009 20:16:40 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19710Jonathan Kehayias<p>I really love the explaination for #5 that you provided. &nbsp;I never really thought much about it, but the history behind the reason is very interesting, at least to me. &nbsp;Thanks for sharing that.</p> http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/08/my-datetime-faq.aspx#19762Fri, 11 Dec 2009 07:51:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19762gbn<p>BOL for SQL Server 2005 states &quot;The other 4 bytes store the time of day represented as the number of 1/300-second units after midnight.&quot;</p> http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/08/my-datetime-faq.aspx#19793Fri, 11 Dec 2009 22:11:58 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19793Kalen Delaney<p>Hi, gbn, I actually knew that but didn't want to have to explain about 'ticks'. I did mention that I was not going to be as technical as I could have been, and told people they could read my books if they like.. I do talk about ticks and the 1/300th of a second time units there.</p> <p>Thanks</p> <p>Kalen </p> http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/08/my-datetime-faq.aspx#19806Sat, 12 Dec 2009 02:35:50 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:19806pwehland<p>How old am I in earth years? </p> <p>SELECT datediff(dd, @my_birthdate, getdate() ) / 365.25</p> <p>How old am I in Martian years? </p> <p>SELECT datediff(dd, @my_birthdate, getdate() ) / 365.25</p> <p>Q: Why is this the same number?</p> <p>A: You are confusing Years with Planetary Orbital Periods! :-)</p>