To convert a datetime to a string in various formats in SQL Server, you can use the CONVERT (arg1, arg2, arg3) function, same like date to a string but with different format codes.

This function is a partial compatibility implementation of MS SQL Server's CONVERT function. It converts a date to a string using the specified style.