Search code examples
sqlsql-serverdatetimeiso8601

Convert ISO-8601 varchar (0000-00-00T00:00:00+00:00) to datetime in SQL

How can I convert 2019-07-01T00:00:00+05:30 to DateTime in SQL?

2019-07-01T00:00:00+05:30 is a varchar field. I need to convert this into DateTime to compare this to a date field.
suggest me a query to Convert (2019-07-01T00:00:00+05:30) into DateTime

Solution

  • Convert To date :

    select cast('2019-07-01T00:00:00+05:30' as Date)

    Convert To time:

    select cast('2019-07-01T00:00:00+05:30' as Time)

    Convert To datetime :

    select convert(datetime2, '2019-07-01T10:00:30+05:30',0)