CONVERTing data
Another important function similar to CAST() is CONVERT(). They are very similar in functionality, with the exception that with CONVERT() you can use a style parameter for changing the aspect of a date. Also, CONVERT() is SQL Server specific, so its performance is slightly better than CAST().
Nonetheless, it's important to know how to use both of them.
In this exercise, you are going to enhance your knowledge of the CONVERT() function.
Deze oefening maakt deel uit van de cursus
Functions for Manipulating Data in SQL Server
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
SELECT
email,
-- Convert birthdate to varchar show it like: "Mon dd,yyyy"
___(varchar, ___, 107) AS birthdate
FROM voters;