Stackoverflow - Extract Date with different format from a text field, Sql Server

Stackoverflow - Extract Date with different format from a text field

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 4, rows affected: 4, absolute service time: 0,16 sec

edit mode | history

  
DateAsString
DateAsDate

1
4/1/17
01.04.2017 00:00:00

2
04/1/17
01.04.2017 00:00:00

3
4/01/17
01.04.2017 00:00:00

4
04/01/17
01.04.2017 00:00:00

λ

                                      .NET NoSQL database for rapid development