Date_format

Format

Description

%a

Abbreviated weekday name (Sun to Sat)

%b

Abbreviated month name (Jan to Dec)

%c

Numeric month name (0 to 12)

%D

Day of month, numeric, follwed by suffix (1st, 2nd, 3rd, …)

%d

Day of month, numeric (01 to 31)

%e

Day of month, numeric (1 to 31)

%f

Microseconds (000000 to 999999)

%H

Hour (00 to 23)

%h

Hour (00 to 12)

%I

??? Hour (00 to 12)

%i

Minutes (00 to 59)

%j

Day of year (001 to 366)

%k

Hour (0 to 23)

%l

Hour (1 to 12)

%M

Month name full (January to December)

%m

Month name, numeric (00 to 12)

%p

AM or PM

%r

Time in 12 hour AM or PM format (hh:mm:ss AM/PM)

%S

Seconds (00 to 59)

%s

Seconds (00 to 59)

%T

Time in 24 hour format (hh:mm:ss)

%U

Week where Sunday is the first day of the week (00 to 53)

%u

Week where Monday is the first day of the week (00 to 53)

%V

Week where Sunday is the first day of the week (01 to 53) used with %X

%v

Week where Monday is the first day of the week (01 to 53) used with %x

%W

Weekday name in full (Sunday to Saturday)

%w

Day of the week where Sunday = 0 and Saturday = 6

%X

Year for the week where Sunday is the first day of the week. Used with %V

%x

Year for the week where Monday is the first day of the week. Used with %v

%Y

Year, numeric, 4 digits

%y

Year, numeric, 2 digits