SQL-ALTER DATETIME COLUMN TO VARCHAR WITH EXISTING DATA, Sql Server

SQL-ALTER DATETIME COLUMN TO VARCHAR WITH EXISTING DATA

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 10, rows affected: 5, absolute service time: 0,17 sec

edit mode | history

  
id
LastUpdateDate

1
1
18.04.2017 10:31:50

2
2
19.04.2017 10:31:50

3
3
20.04.2017 10:31:50

4
4
21.04.2017 10:31:50

5
5
22.04.2017 10:31:50


  
id
LastUpdateDate

1
1
18.04.2017 00:00:00

2
2
19.04.2017 00:00:00

3
3
20.04.2017 00:00:00

4
4
21.04.2017 00:00:00

5
5
22.04.2017 00:00:00

λ

                                      .NET NoSQL database for rapid development