J Livingston SQL (9/27/2016)

---

drew.allen (9/27/2016)

---

Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime. It's not like the datetime data is sensitive, and it certainly isn't human legible.

Drew

if you use the SSMS GUI for "generate scripts" and "schema and data".....MS used to script as such...cant remember which version it changed on though

in SQL 2016 it scripts as CAST(N'2016-08-20T22:25:00.000' AS DateTime)