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

  • June 14, 2011 at 7:18 am

    #1338357

    I use these as I figure it's better to use SQL servers internal function than assume Datetime will always be a float:

    DECLARE @DateOnly DATETIME

    SET @DateOnly = CAST(CONVERT(varchar,GetDate(),112) AS DATETIME)

    SELECT @DateOnly

    SET @DateOnly = CAST(CONVERT(varchar(10),GetDate(),121) AS DATETIME)

    SELECT @DateOnly