Home Forums SQL Server 2008 T-SQL (SS2K8) Sql Server 2008: Conversion From Text data type to Datetime RE: Sql Server 2008: Conversion From Text data type to Datetime

  • December 11, 2012 at 4:28 am

    #1567361

    Convert to VARCHAR then convert to datetime.

    CONVERT(DATETIME,CONVERT(VARCHAR,vchValue))

    The following link details what can and cannot be converted

    http://msdn.microsoft.com/en-us/library/ms187928.aspx