SQLZOO, Format a date and time.

Format a date and time.

Mimer
Many engines support the SQL standard - see Mimer for details.	SELECT CAST(EXTRACT(DAY FROM wk) AS VARCHAR(2)) \|\| '/' \|\| CAST(EXTRACT(MONTH FROM wk) AS VARCHAR(2)) \|\| '/' \|\| CAST(EXTRACT(YEAR FROM wk) AS VARCHAR(4)), song FROM totp WHERE singer='Tom Jones'
Specific to Mimer
Create a string representing a date to a particular format The Standard provides us with the EXTRACT function that can be used however many engines provide a more convenient alternative. EXTRACT EXRESSION as:`EXTRACT(MONTH FROM wk)` other components that may be extracted: YEAR MONTH DAY HOUR MINUTE In this example we use CAST in order to build up a date in the UK format dd/mm/yyyy

SQLzoo.net