DATE_FORMAT

PostgreSQL equivalent:

Formats a date as a string according to the given format.

MySQL 8.1

DATE_FORMAT(datetime, format)

Parameters

A string; month and weekday names are in English by default; NULL if any argument is NULL

MySQL 8.1

SELECT DATE_FORMAT('2022-06-16 16:37:03', '%d.%m.%Y %H:%i') AS formatted;

formatted
16.06.2022 16:37

MySQL 8.1

SELECT DATE_FORMAT('2022-06-16 16:37:03', '%W, %M %D %Y, %h:%i %p') AS formatted;

formatted
Thursday, June 16th 2022, 04:37 PM

MySQL 8.1

SELECT member_name,
	DATE_FORMAT(birthday, '%d.%m.%Y') AS birth_date
FROM FamilyMembers;

Specifier	Output
%a	Abbreviated weekday name (Sun..Sat)
%b	Abbreviated month name (Jan..Dec)
%c	Month number without a leading zero (0..12)
%D	Day of the month with an English suffix (0th, 1st, 2nd, 3rd…)
%d	Day of the month with a leading zero (00..31)
%e	Day of the month without a leading zero (0..31)
%f	Microseconds (000000..999999)
%H	Hour with a leading zero (00..23)
%h	Hour in 12-hour format with a leading zero (01..12)
%I	Same as %h (01..12)
%i	Minutes with a leading zero (00..59)
%j	Day of the year with leading zeros (001..366)
%k	Hour without a leading zero (0..23)
%l	Hour in 12-hour format without a leading zero (1..12)
%M	Month name (January..December)
%m	Month number with a leading zero (00..12)
%p	AM or PM
%r	Time in 12-hour format (hh:mm:ss AM or PM)
%S	Seconds with a leading zero (00..59)
%s	Same as %S (00..59)
%T	Time in 24-hour format (hh:mm:ss)
%U	Week (00..53), Sunday is the first day, as WEEK with mode 0
%u	Week (00..53), Monday is the first day, as WEEK with mode 1
%V	Week (01..53), Sunday is the first day, as WEEK with mode 2; used with %X
%v	Week (01..53), Monday is the first day, as WEEK with mode 3; used with %x
%W	Weekday name (Sunday..Saturday)
%w	Weekday number (0 is Sunday, 6 is Saturday)
%X	Year of the week for %V, four digits
%x	Year of the week for %v, four digits
%Y	Year, four digits
%y	Year, two digits
%%	The % character