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:00 am

    #775181

    it doesn't wait until noon to start rounding up...

    DECLARE @TheDate DATETIME

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

    SELECT@TheDate

    SELECTCAST(@TheDate AS INT)

    SELECTCAST(CAST(@TheDate AS INT) AS DATETIME)

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

    SELECT@TheDate

    SELECTCAST(@TheDate AS INT)

    SELECTCAST(CAST(@TheDate AS INT) AS DATETIME)

    [font="Arial Narrow"]bc[/font]