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.