Convert “nvarchar” column data type to "DateTime", Sql Server

Convert “nvarchar” column data type to "DateTime"

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 13, rows affected: 18, absolute service time: 0,2 sec, absolute service time: 0,2 sec

fork mode | history

  
Id
UpdatedDate

1
3
02-30-2020 12:00:00 AM

2
4
1-06-2020 12:00:00 ZM

3
6
13-06-2020 13:00:00 PM

4
9
Not a date at all...


  
Id
UpdatedDate

1
1
06.01.2020 00:00:00

2
2
17.06.2020 00:00:00

3
3
NULL

4
4
NULL

5
5
06.01.2020 13:00:00

6
6
NULL

7
7
06.01.2020 13:00:00

8
8
06.01.2020 01:00:00

9
9
NULL

λ

                                      .NET NoSQL database for rapid development