• i didn't get any error.

    SET NOCOUNT ON

    DECLARE @crdate DATETIME,

    @days varchar(3),

    @hr VARCHAR(50),

    @min-2 VARCHAR(5)

    SELECT @crdate=crdate FROM sysdatabases WHERE name='tempdb'

    SET @min-2 = DATEDIFF (mi,@crdate,GETDATE())

    PRINT @min-2

    PRINT '-------------'

    SET @days= @min-2/1440

    print @days

    PRINT '-------------'

    Result:

    24293

    ------------------------

    16

    ------------------------

    SQL DBA.