Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano T-SQL RE: T-SQL

  • February 17, 2009 at 9:11 am

    #945269

    skjoldtc (2/17/2009)

    Points schmointz... who cares?

    The takeaway is that SQL Server rounds time and don't use BETWEEN with a date range. But, this seems such a strange way to do this. What is the rationale? Can anyone explain that? Do other databases handle time the same way? It seems so counter-intuitive.

    :unsure:

    I think it actually comes down to how the data is stored in binary in the system, but I may be wrong.