I have a need to use many date formats. The following SP lists the conversion codes and the length of the output.

CREATE procedure pDisplayDateConversionStyles as

print 'datetime to Varchar conversion...