sorting by transdate, Sql Server - rextester

Run Code | API | Code Wall | Misc | Feedback | Login | Theme | Privacy | Patreon

sorting by transdate

Language: Layout:

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

edit mode | history

  
emp#
empName
transDate
vc_converted
vc_casted
dt_converted

1
102
bbbb
2016-01-01 15:41:48.417
2016-01-01
2016-01-01
01.01.2016 00:00:00

2
103
cccc
2016-02-01 15:41:48.417
2016-02-01
2016-02-01
01.02.2016 00:00:00

3
101
aaaa
2016-03-01 15:41:48.417
2016-03-01
2016-03-01
01.03.2016 00:00:00

λ

                                      .NET NoSQL database for rapid development