SQL Server datetime in format yyyy-mm-ddThh:mi:ss.mmmZ, Sql Server - rextester

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

SQL Server datetime in format yyyy-mm-ddThh:mi:ss.mmmZ

Language: Layout:

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

latest | history

  
i
timestamp
ce
dto3
plusZ

1
1
13.09.2017 01:00:00
2017-09-13T01:00:00.003Z
2017-09-13T01:00:00.003Z
2017-09-13T01:00:00.003Z

2
2
13.09.2017 02:00:00
2017-09-13T02:00:00.333Z
2017-09-13T02:00:00.333Z
2017-09-13T02:00:00.333Z

3
3
13.09.2017 03:00:00
2017-09-13T03:00:00Z
2017-09-13T03:00:00Z
2017-09-13T03:00:00Z

4
4
13.09.2017 04:00:00
2017-09-13T04:00:00Z
2017-09-13T04:00:00Z
2017-09-13T04:00:00Z

5
5
13.09.2017 14:12:34
2017-09-13T14:12:34.567Z
2017-09-13T14:12:34.567Z
2017-09-13T14:12:34.567Z

λ

                                      .NET NoSQL database for rapid development