Search
-
Sript As Insert function adds character T for datetime column
Every time I use this function (Script as INSERT) on a result set that contains datetime values, then clicking on Script as INSERT option, I noticed that a character 'T' is added in the date column value. It automatically gets placed between date and time. E.g. If I run a select statement to get values from a column of… -
Re: Sript As Insert function adds character T for datetime column
Hi Sushant, The T is added because of the ISO 8601 format: https://en.wikipedia.org/wiki/ISO_8601 The advantage in using the ISO 8601 format is that it is an international standard with unambiguous specification. Also, this format isn't affected by the SET DATEFORMAT or SET LANGUAGE setting. Can you please post your idea…
2 results