Home Forums SQL Server 2008 T-SQL (SS2K8) Convert Text to Date DataType RE: Convert Text to Date DataType

  • August 16, 2012 at 11:39 pm

    #1526907

    Instead of 103 use 03

    DECLARE @D CHAR(10) = '17/08/12'

    SELECT CONVERT(date, @D, 03)

    --Vadim R.