Home Forums SQL Server 2008 T-SQL (SS2K8) Selection using date held as a string RE: Selection using date held as a string

  • April 3, 2013 at 1:25 am

    #1603041

    umarrizwan (4/2/2013)

    issue is with varchar value 'z' in data ('2013-10-29 22:59:00Z) and you are converting it to datetime or datetime2.

    Datetime2 handles the 'z', Datetime does not