CODEWITHSUNDEEP
sql-serverdatetime2
Display name
Display name

Reputation: 1

DateTime2 prefixed with "T"

When using Tasks - Generate Scripts... it is now generating the DateTime2 with a Prefix of "T" for the time (example 1) instead of leaving it blank (example 2). How do I remove the Prefix "T" when generating my scripts?

Example 1: CAST(N'2017-04-18T00:00:00.0000000' AS DateTime2)

Example 2: CAST(N'2017-04-18 00:00:00.0000000' AS DateTime2)

I have tried generating at a previous version of SQL i.e. 2008 or 2012 to see if it was a versioning issues which still did not work.

Upvotes: 0

Views: 54

Answers (0)

Related Questions