Home Forums SQL Server 7,2000 T-SQL convert char to datetime RE: convert char to datetime

  • July 13, 2004 at 11:35 pm

    #514502

    you could also try this:

    SELECT CAST(CONVERT(char(10), getdate(), 112) as datetime)