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

  • March 29, 2010 at 9:45 am

    #1141523

    here's my 2p

    print convert(datetime,cast(2009*10000+3*100 + 5 as varchar(8)),112)

    just wondered exactly the same question...in fact here is my last day of the month bit

    set @DealDateTo=dateadd(dd,-1,dateadd(mm,1,convert(datetime,cast(@DealYear*10000+@DealMonth*100 + 1 as varchar(8)),112)))