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

  • July 30, 2009 at 12:10 am

    #1032188

    In SQL-Server 2008: usenew datatype date

    DECLARE @DateOnly DATETIME

    SET @DateOnly = CAST(CAST(GetDate() AS Date) AS DATETIME)

    SELECT @dateonly