Home Forums SQL Server 2005 T-SQL (SS2K5) Date Conversion Fails in Stored Procedure - But code works in a Trigger !? RE: Date Conversion Fails in Stored Procedure - But code works in a Trigger !?

  • May 7, 2013 at 5:19 am

    #1612917

    Why not avoid the datatype conversions completely?

    declare @Today date

    declare @NowTime time

    select @Today = getdate()

    ,@NowTime = getdate()

    select @Today

    ,@NowTime

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.