Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jano Petras Get DATE part of the DATETIME RE: Get DATE part of the DATETIME

  • February 5, 2008 at 9:25 am

    #775197

    DECLARE @TheDate DATETIME, @HalfDayAndaBit DECIMAL (14,13)

    SET @HalfDayAndaBit = 0.5000000385803

    SET @TheDate = '2008-02-05 11:59:59.993'

    SELECT @TheDate

    SELECT CAST(@TheDate-@HalfDayAndaBit AS INT)

    SELECT CAST(CAST(@TheDate-@HalfDayAndaBit AS INT) AS DATETIME)

    SET @TheDate = '2008-02-05 11:59:59.997'

    SELECT @TheDate

    SELECT CAST(@TheDate-@HalfDayAndaBit AS INT)

    SELECT CAST(CAST(@TheDate-@HalfDayAndaBit AS INT) AS DATETIME)

    That's where the 'AndaBit' comes in.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden