Home Forums SQL Server 2005 T-SQL (SS2K5) Get Date only from getdate() function RE: Get Date only from getdate() function

  • March 31, 2010 at 4:34 am

    #1142945

    Also asked here

    http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/d12f8277-d921-4c92-9f03-a7019678cd7e

    I answered

    SELECT CAST(GETDATE() AS DATE)

    N 56°04'39.16"
    E 12°55'05.25"