• 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


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter