***Note from Migration:***
Original Title was: Add a SQL Server Date format to @DateFormatter function and DateCalculator transformer
Microsoft SQL Server (at least on 2012) only allows timestamps containing milliseconds (3 decimal places for fractional seconds) to be written to datetime and datetime2 columns. Dates generated by the @DateTimeNow() function automatically include nanoseconds (9 decimal places for fractional seconds). There is currently no way in the @DateTimeFormat function or DateCalculator transformer to only return milliseconds. Using either the "ISO" format shortcut, or using the %S flag always passes nanoseconds. One workaround I found was to wrap the @DateTimeNow() in a @Format() function like this: @DateTimeFormat(@Format(%.3f,@DateTimeNow()),ISO) to truncate the extra digits.
I propose adding a "SQLServer" shortcut that returns the timestamp with only millisecond precision, and a flag of some sort that returns the seconds to millisecond precision.
