I'm sorry, but the only thing this stored procedure does is to show the various formats available when converting a datetime field to a string value.

It is a stored procedure. Once you compile it you can run it as below:

EXEC sp_datetime_formats

or

sp_datetime_formats (if no other SQL statement)