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.