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.

Convert() function is basically used to converts an expression of one data type to another data type. this function display date/time data in different ...

Figure 4: Correct Date Format with “dd/mm/yy” British/French date style Example 2: Sometimes, string-to-date conversion in SQL Server results in an error, not because of the date or time formats used, ...