This stored procedure will show all possible datetime formats when used with the style argument in the CONVERT() function. It also shows sample output from the date part arguments.
2016-04-13 (first published: 2014-10-10)
This script converts a number of seconds (integer) to a time string, format 'hh:mm:ss'
2010-05-05 (first published: 2010-04-28)