Format dates
From SQLZoo
Format a date and time.
schema:gisq
Many engines support the SQL standard - see Mimer for details.
SELECT STRFTIME('%d/%m/%Y', wk), song
FROM totp
WHERE singer='Tom Jones'
SELECT CHAR(wk, eur),
song
FROM totp
WHERE singer='Tom Jones'
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'
SELECT FORMAT(wk, 'DD/MM/YYYY'),
song
FROM totp
WHERE singer='Tom Jones'
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'
SELECT TO_CHAR(wk, 'DD/MM/YYYY'), song
FROM gisq.totp
WHERE singer='Tom Jones'
SELECT CONVERT(VARCHAR(10), wk, 103), song
FROM totp
WHERE singer='Tom Jones'
SELECT DATE_FORMAT(wk,'%d/%m/%Y'), song
FROM totp
WHERE singer='Tom Jones'
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'
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'
