Home Forums SQL Server 2014 Development - SQL Server 2014 SQL Function to convert date time to string RE: SQL Function to convert date time to string

  • January 28, 2014 at 3:55 pm

    #1684093

    Greetings!

    Would using date type 112 not remove the need to replace the "/" characters in the date string?

    This would reduce the date string portion from

    REPLACE(CONVERT(VARCHAR(10),@dt,111),'/','')

    to

    CONVERT(VARCHAR(8),@dt,112)