demonfox (3/17/2013)
L' Eomot Inversé (3/16/2013)
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest. 😉+1
May be, because, it's monday it looked like too much english and a long script to read . Then, I finally decided to go on with the question .. In the end, I realised it is a question about datetime millisecond precision :w00t:
eventually it was a worthy read ,a simple query with calm mind ...:-P
thanks for the question
Edit: english
+2
Also good to see sql 2012 function "DATETIMEFROMPARTS" as well.
Thanks Ron!
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter