This project is read-only.

Date format in AuditDetail OldValue and NewValue fields

Nov 26, 2013 at 11:13 AM
is it possible to change convert style from 113 to 121?
You use in triggers someting like: convert(varchar(50),deleted.[DateFrom],113)
I would change it to: convert(varchar(50),deleted.[DateFrom],123)

If style is 113, then I get "26 Nov 2013 12:10:11:160"
If style is 121, then I get "2013-11-26 12:10:36.117"

I think style ODBC style for date is more readable to not EN users if they browse _RowHistory.
This change should not breake anything.

Of course I can change date convert styles in my version of script, if you insist on 113

Nov 26, 2013 at 11:43 PM
I will add a parameter to the script to allow Users to specify the date style they wish to use between 113 and 121.

Marked as answer by JohnSigouin on 11/26/2013 at 3:43 PM
Nov 26, 2013 at 11:43 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Nov 29, 2013 at 9:41 AM
Yes i would agree with this

good point