This worked perfectly with

brad2575 — Wed, 07 May 2008 13:07:51 -0400

This worked perfectly with only 1 change needed (to point to my previously created Regular Expression change function). Just copied/pasted and created the function and worked perfectly!!

I tweaked it to allow the time to be added to the date if you pass a 'Y' flag as a 3rd imput varable but the only formatting that is done for this is: convert(varchar, @inputDate, 114)

So if you pass "Y" to the function it will take the time from the input variable using the above function (if no time passed just formats all "0"'s in the time format.

SQL Zone - Comments for "Custom Date Formatting in SQL Server"

This worked perfectly with