Home Forums SQL Server 2005 T-SQL (SS2K5) Set Variable based on a SELECT RE: Set Variable based on a SELECT

  • February 10, 2010 at 8:40 am

    #1116882

    DECLARE @mydate varchar(20)

    SELECT @myDate = CONVERT(CHAR(9),GETDATE(),1) + SUBSTRING(CONVERT(CHAR(5),GETDATE(),14),1,5) + ' '

    print @mydate

    Converting oxygen into carbon dioxide, since 1955.