Date format in AuditDetail OldValue and NewValue fields

Nov 26, 2013 at 10:13 AM
Hi,
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

Robert
Coordinator
Nov 26, 2013 at 10: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.

John
Marked as answer by JohnSigouin on 11/26/2013 at 3:43 PM
Coordinator
Nov 26, 2013 at 10: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 8:41 AM
Yes i would agree with this

good point