Home Forums SQL Server 7,2000 T-SQL cast varchar as datetime RE: cast varchar as datetime

  • May 17, 2003 at 10:48 pm

    #457561

    CREATE FUNCTION MyStrip(@v varchar(50)) RETURNS DateTime AS

    BEGIN

    Declare @vv Varchar(50)

    Set @vv=Right(@v,DataLength(@v)-CharIndex(' ',@v))

    RETURN Cast(Left(@vv,DataLength(@vv)-CharIndex(' ',Reverse(@vv))) as DateTime)

    END

    Select dbo.MyStrip('Fri, 06 Dec 2002 14:52:26 -0500')

    Select dbo.MyStrip('Fri, 6 Dec 2002 15:08:59 EST')