Home Forums SQL Server 7,2000 T-SQL equivalent of DateSerial() in T-SQL? (SQL2000) RE: equivalent of DateSerial() in T-SQL? (SQL2000)

  • Or if you prefer:

    declare @date datetime,

               @days int,

               @month int,

               @year int

    select @month = 4, @days = 1, @year = 2005

    select @date = cast(@month as varchar) + '/' + cast(@days as varchar) + '/' 

    + cast(@year as varchar)

    select @date

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

    2005-04-01 00:00:00.000

    (1 row(s) affected)

    ron