Formatting Dates on MySQL
You will love this blog because date functions and formatting differ dramatically between databases, but I have covered that with brilliant examples and clear and concise explanations below.
All of these examples have come from my books and training classes. Please do me a favor and tell your training coordinator that you know the best technical trainer in the world. Ask them to hire me to train at your company, either on-site or with a virtual class. They can see our classes, outlines, and a sample of my teaching at this link on our website.
https://coffingdw.com/education/
Do you need to format dates on MySQL? MySQL uses the DATE_FORMAT command to transform raw date or timestamp data to your desired format. This blog will brilliantly break down and explain everything about formatting a MySQL date so you can choose what works best for you.
I will start with the basics, give you all the specifiers so you can put together the format you want, show you some top standards worldwide, provide you with another table with the most popular formats per industry in the United States, and then finally, provide you with a table that has over 800 examples.
Below is a picture of a query to see the syntax of the DATE_FORMAT function. I am also providing a quick cheat sheet so you can see some of the common components used in the DATE_FORMAT command.
%Y: Four-digit year.
%y: Two-digit year.
%m: Month (01-12).
%d: Day of the month (01-31) with leading zero.
%e: Day of the month (1-31).
%j: Day of the year.
%M: Name of month capitalized..
%b: Abbreviated month name (e.g., Jan, Feb).
%W: Name of the day of the week in all caps.
%a: Abbreviated day of the week capitalized (e.g., Sun, Mon).
%u: The week of the year.
I bet you didn’t know you could use the DATE_FORMAT function in the WHERE and AND clauses to filter rows. The query below only returns rows where the customer_timestamp has a month of December, a day of Saturday, a minute of 54, and a second of 35.
Below is a picture to show you the specifiers you can use to format a date using the DATE_FORMAT command.
Below is a table with the most popular formats worldwide to give examples of different standards.
| MySQL_DATE_FORMAT_SYNTAX | DESIRED_OUTPUT |
|---|---|
| DATE_FORMAT(CURRENT_DATE, '%m/%d/%Y') as UNITED_STATES -- (MM/DD/YYYY) | 01/21/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%d') as CANADA -- (YYYY-MM-DD) | 2024-01-21 |
| DATE_FORMAT(CURRENT_DATE, '令和%Y年%m月%d日') as JAPAN -- (令和元年01月21日) | 2024年01月21日 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as UNITED_KINGDOM -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%Y') as GERMANY -- (DD.MM.YYYY) | 21.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as FRANCE -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y年%m月%d日') as CHINA -- (YYYY年MM月DD日) | 2024年01月21日 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as AUSTRALIA -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d-%m-%Y') as INDIA -- (DD-MM-YYYY) | 21-01-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as BRAZIL -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%Y') as RUSSIA -- (DD.MM.YYYY) | 21.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%m/%d') as SOUTH_AFRICA -- (YYYY/MM/DD) | 2024/01/21 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as ITALY -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as SPAIN -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as MEXICO -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%d') as SWEDEN -- (YYYY-MM-DD) | 2024-01-21 |
| DATE_FORMAT(CURRENT_DATE, '%d-%m-%Y') as NETHERLANDS -- (DD-MM-YYYY) | 21-01-2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y년 %m월 %d일') as SOUTH_KOREA -- (YYYY년 MM월 DD일) | 2024년01월21일 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as SAUDI_ARABIA -- (DD/MM/YYYY) | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') as ARGENTINA -- (DD/MM/YYYY) | 21/01/2024 |
Here is a table with MySQL format examples from industries in the United States you might want to consider.
| TOP_FORMATS_PER_US_INDUSTRY | DESIRED_OUTPUT |
|---|---|
| DATE_FORMAT(CURRENT_DATE, '%m/%d/%Y') AS finance_date_format_1 | 01/21/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%d') AS finance_date_format_2 | 2024-01-21 |
| DATE_FORMAT(CURRENT_DATE, '%m-%d-%Y') AS retail_date_format_1 | 01-21-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') AS retail_date_format_2 | 21/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%m.%d') AS airlines_date_format_1 | 2024.01.21 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%Y') AS airlines_date_format_2 | 21.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%m/%d') AS medical_date_format_1 | 2024/01/21 |
| DATE_FORMAT(CURRENT_DATE, '%m-%d-%Y') AS medical_date_format_2 | 01-21-2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y%m%d') AS social_media_date_format_1 | 20240121 |
| DATE_FORMAT(CURRENT_DATE, '%m%d%Y') AS social_media_date_format_2 | 01212024 |
| DATE_FORMAT(CURRENT_DATE, '%m.%d.%Y') AS insurance_date_format_1 | 01.21.2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%m/%d') AS insurance_date_format_2 | 2024/01/21 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%d') AS scientific_date_format_1 | 2024-01-21 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%Y') AS scientific_date_format_2 | 21.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%m/%d/%Y') AS real_estate_date_format_1 | 01/21/2024 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%m.%d') AS real_estate_date_format_2 | 2024.01.21 |
Here is a table with 800 examples of MySQL date formats I tested so you know they will work.
| DATE_FORMAT_SYNTAX | DESIRED_OUTPUT |
|---|---|
| CURRENT_DATE | 2024-01-07 |
| DATE_FORMAT(CURRENT_DATE, '%Y') -- 4-digit year | 2024 |
| DATE_FORMAT(CURRENT_DATE, '%y') -- Last 2 digits of year | 24 |
| DATE_FORMAT(CURRENT_DATE, '%c') -- %c - Numeric month name (0 to 12) | 1 |
| DATE_FORMAT(CURRENT_DATE, '%m') -- %m - Month name as a numeric value (00 to 12) | 01 |
| DATE_FORMAT(CURRENT_DATE, '%b') -- %b - Abbreviated month name (Jan to Dec) | Jan |
| DATE_FORMAT(CURRENT_DATE, '%M') -- %M - Month name in full (January to December) | January |
| DATE_FORMAT(CURRENT_DATE, '%U') -- %U - Week where Sunday is the first day of the week (00 to 53) | 01 |
| DATE_FORMAT(CURRENT_DATE, '%u') -- %u - Week where day is the first day of the week (00 to 53) | 01 |
| DATE_FORMAT(CURRENT_DATE, '%V') -- %V - Week where Sunday is the first day of the week (01 to 53). Used with %X | 01 |
| DATE_FORMAT(CURRENT_DATE, '%v') -- %v - Week where %bday is the first day of the week (01 to 53). Used with %x | 01 |
| DATE_FORMAT(CURRENT_DATE, '%X') -- %X - Year for the week where Sunday is the first day of the week. Used with %V | 2024 |
| DATE_FORMAT(CURRENT_DATE, '%x') -- %x - Year for the week where %bday is the first day of the week. Used with %v | 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a') -- %a - Abbreviated weekday name (Sun to Sat) | Sun |
| DATE_FORMAT(CURRENT_DATE, '%W') -- %W - Weekday name in full (Sunday to Saturday) | Sunday |
| DATE_FORMAT(CURRENT_DATE, '%w') -- %w - %W of the week where Sunday=0 and Saturday=6 | 0 |
| DATE_FORMAT(CURRENT_DATE, '%j') -- %j - %W of the year (001 to 366) | 007 |
| DATE_FORMAT(CURRENT_DATE, '%d') -- %d - %W of the month as a numeric value (01 to 31) | 07 |
| DATE_FORMAT(CURRENT_DATE, '%e') -- %e - month as a numeric value (0 to 31) | 7 |
| DATE_FORMAT(CURRENT_DATE, '%D') -- %D - %W of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...) | 7th |
| DATE_FORMAT(CURRENT_DATE, '%h') -- %h - Hour (00 to 12) | 12 |
| DATE_FORMAT(CURRENT_DATE, '%I') -- %I -Hour (00 to 12) | 12 |
| DATE_FORMAT(CURRENT_DATE, '%H') -- %H - Hour (00 to 23) | 00 |
| DATE_FORMAT(CURRENT_DATE, '%k') -- %k - Hour (0 to 23) | 0 |
| DATE_FORMAT(CURRENT_DATE, '%l') -- %l - Hour (1 to 12) | 12 |
| DATE_FORMAT(CURRENT_DATE, '%r') -- %r - Time in 12 hour AM or PM FORMAT (hh:mm:ss AM/PM) | 12:00:00 AM |
| DATE_FORMAT(CURRENT_DATE, '%i') -- %i - Minutes (00 to 59) | 00 |
| DATE_FORMAT(CURRENT_DATE, '%S') -- %S - Seconds (00 to 59) | 00 |
| DATE_FORMAT(CURRENT_DATE, '%s') -- %s - Seconds (00 to 59) | 00 |
| DATE_FORMAT(CURRENT_DATE, '%T') -- %T - Time in 24 hour FORMAT (hh:mm:ss) | 00:00:00 |
| DATE_FORMAT(CURRENT_DATE, '%f') -- %f - Microseconds (000000 to 999999) | 000000 |
| DATE_FORMAT(CURRENT_DATE, '%p') -- %p - AM or PM | AM |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%d') | 2024-01-07 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%m-%e') | 2024-01-7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%c-%e') | 2024-1-7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%c-%d') | 2024-1-07 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%m/%d') | 2024/01/07 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%c/%e') | 2024/1/7 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%c/%d') | 2024/1/07 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%c:%d') | 2024:1:07 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%m:%e') | 2024:01:7 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%c:%e') | 2024:1:7 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%c.%d') | 2024.1.07 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%m.%e') | 2024.01.7 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%c.%e') | 2024.1.7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %c %d') | 2024 1 07 |
| DATE_FORMAT(CURRENT_DATE, '%Y %c %e') | 2024 1 7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %j') | 2024 007 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%j.%e') | 2024.007.7 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%b.%e') | 2024.Jan.7 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%M.%e') | 2024.January.7 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%j') | 2024/007 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%j/%e') | 2024/007/7 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%b/%e') | 2024/Jan/7 |
| DATE_FORMAT(CURRENT_DATE, '%Y/%M/%e') | 2024/January/7 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%j') | 2024:007 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%j:%e') | 2024:007:7 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%b:%e') | 2024:Jan:7 |
| DATE_FORMAT(CURRENT_DATE, '%Y:%M:%e') | 2024:January:7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%j') | 2024-007 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%j-%e') | 2024-007-7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%c') | 2024-1 |
| DATE_FORMAT(CURRENT_DATE, '%Y%b%e') | 2024Jan7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%b-%e') | 2024-Jan-7 |
| DATE_FORMAT(CURRENT_DATE, '%Y%M%e') | 2024January7 |
| DATE_FORMAT(CURRENT_DATE, '%Y-%M-%e') | 2024-January-7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %j %e') | 2024 007 7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %j%e') | 2024 0077 |
| DATE_FORMAT(CURRENT_DATE, '%Y %m %e') | 2024 01 7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %b %e') | 2024 Jan 7 |
| DATE_FORMAT(CURRENT_DATE, '%Y %M %e') | 2024 January 7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%m-%d') | 24-01-07 |
| DATE_FORMAT(CURRENT_DATE, '%y/%m/%d') | 24/01/07 |
| DATE_FORMAT(CURRENT_DATE, '%y %j') | 24 007 |
| DATE_FORMAT(CURRENT_DATE, '%y.%j.%e') | 24.007.7 |
| DATE_FORMAT(CURRENT_DATE, '%y.%m.%e') | 24.01.7 |
| DATE_FORMAT(CURRENT_DATE, '%y.%c.%d') | 24.1.07 |
| DATE_FORMAT(CURRENT_DATE, '%y.%c.%e') | 24.1.7 |
| DATE_FORMAT(CURRENT_DATE, '%y.%b.%e') | 24.Jan.7 |
| DATE_FORMAT(CURRENT_DATE, '%y.%M.%e') | 24.January.7 |
| DATE_FORMAT(CURRENT_DATE, '%y/%j') | 24/007 |
| DATE_FORMAT(CURRENT_DATE, '%y/%j/%e') | 24/007/7 |
| DATE_FORMAT(CURRENT_DATE, '%y/%m/%e') | 24/01/7 |
| DATE_FORMAT(CURRENT_DATE, '%y/%c/%d') | 24/1/07 |
| DATE_FORMAT(CURRENT_DATE, '%y/%c/%e') | 24/1/7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%j') | 24:007 |
| DATE_FORMAT(CURRENT_DATE, '%y:%j:%e') | 24:007:7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%b:%e') | 24:Jan:7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%M:%e') | 24:January:7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%j') | 24-007 |
| DATE_FORMAT(CURRENT_DATE, '%y-%j-%e') | 24-007-7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%m-%e') | 24-01-7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%c-%d') | 24-1-07 |
| DATE_FORMAT(CURRENT_DATE, '%y-%c-%e') | 24-1-7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%m:%e') | 24:01:7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%c:%e') | 24:1:7 |
| DATE_FORMAT(CURRENT_DATE, '%y:%c:%d') | 24:1:07 |
| DATE_FORMAT(CURRENT_DATE, '%y.%j') | 24.007 |
| DATE_FORMAT(CURRENT_DATE, '%Y.%j') | 2024.007 |
| DATE_FORMAT(CURRENT_DATE, '%y%c%e') | 2417 |
| DATE_FORMAT(CURRENT_DATE, '%y%j') | 24007 |
| DATE_FORMAT(CURRENT_DATE, '%y%m%e') | 24017 |
| DATE_FORMAT(CURRENT_DATE, '%y%c%d') | 24107 |
| DATE_FORMAT(CURRENT_DATE, '%y/%M/%e') | 24/January/7 |
| DATE_FORMAT(CURRENT_DATE, '%y/%b/%e') | 24/Jan/7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%M-%e') | 24-January-7 |
| DATE_FORMAT(CURRENT_DATE, '%y%M%e') | 24January7 |
| DATE_FORMAT(CURRENT_DATE, '%y-%b-%e') | 24-Jan-7 |
| DATE_FORMAT(CURRENT_DATE, '%y%b%e') | 24Jan7 |
| DATE_FORMAT(CURRENT_DATE, '%c-%d-%y') | 1-07-24 |
| DATE_FORMAT(CURRENT_DATE, '%c-%d-%Y') | 1-07-2024 |
| DATE_FORMAT(CURRENT_DATE, '%c-%e-%y') | 1-7-24 |
| DATE_FORMAT(CURRENT_DATE, '%c-%e-%Y') | 1-7-2024 |
| DATE_FORMAT(CURRENT_DATE, '%m-%d-%y') | 01-07-24 |
| DATE_FORMAT(CURRENT_DATE, '%m-%d-%Y') | 01-07-2024 |
| DATE_FORMAT(CURRENT_DATE, '%m-%e-%y') | 01-7-24 |
| DATE_FORMAT(CURRENT_DATE, '%m-%e-%Y') | 01-7-2024 |
| DATE_FORMAT(CURRENT_DATE, '%c/%d/%y') | 1/07/24 |
| DATE_FORMAT(CURRENT_DATE, '%c/%d/%Y') | 1/07/2024 |
| DATE_FORMAT(CURRENT_DATE, '%m/%e/%y') | 01/7/24 |
| DATE_FORMAT(CURRENT_DATE, '%m/%e/%Y') | 01/7/2024 |
| DATE_FORMAT(CURRENT_DATE, '%c/%e/%y') | 1/7/24 |
| DATE_FORMAT(CURRENT_DATE, '%c/%e/%Y') | 1/7/2024 |
| DATE_FORMAT(CURRENT_DATE, '%m:%d:%y') | 01:07:24 |
| DATE_FORMAT(CURRENT_DATE, '%m:%e:%y') | 01:7:24 |
| DATE_FORMAT(CURRENT_DATE, '%c:%d:%y') | 1:07:24 |
| DATE_FORMAT(CURRENT_DATE, '%c:%e:%y') | 1:7:24 |
| DATE_FORMAT(CURRENT_DATE, '%c:%d:%Y') | 1:07:2024 |
| DATE_FORMAT(CURRENT_DATE, '%c:%e:%Y') | 1:7:2024 |
| DATE_FORMAT(CURRENT_DATE, '%m:%d:%Y') | 01:07:2024 |
| DATE_FORMAT(CURRENT_DATE, '%m:%e:%Y') | 01:7:2024 |
| DATE_FORMAT(CURRENT_DATE, '%c%e%Y') | 172024 |
| DATE_FORMAT(CURRENT_DATE, '%m%e%Y') | 0172024 |
| DATE_FORMAT(CURRENT_DATE, '%c-%e') | 1-7 |
| DATE_FORMAT(CURRENT_DATE, '%c/%d') | 1/07 |
| DATE_FORMAT(CURRENT_DATE, '%c%d%y') | 10724 |
| DATE_FORMAT(CURRENT_DATE, '%m%d%y') | 010724 |
| DATE_FORMAT(CURRENT_DATE, '%c-%Y') | 1-2024 |
| DATE_FORMAT(CURRENT_DATE, '%c/%Y') | 1/2024 |
| DATE_FORMAT(CURRENT_DATE, '%m-%Y') | 01-2024 |
| DATE_FORMAT(CURRENT_DATE, '%m/%Y') | 01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%c%Y') | 12024 |
| DATE_FORMAT(CURRENT_DATE, '%m%Y') | 012024 |
| DATE_FORMAT(CURRENT_DATE, '%c-%d') | 1-07 |
| DATE_FORMAT(CURRENT_DATE, '%c/%e') | 1/7 |
| DATE_FORMAT(CURRENT_DATE, '%c:%d') | 1:07 |
| DATE_FORMAT(CURRENT_DATE, '%c:%e') | 1:7 |
| DATE_FORMAT(CURRENT_DATE, '%m:%d') | 01:07 |
| DATE_FORMAT(CURRENT_DATE, '%m:%e') | 01:7 |
| DATE_FORMAT(CURRENT_DATE, '%c:%y') | 1:24 |
| DATE_FORMAT(CURRENT_DATE, '%m:%y') | 01:24 |
| DATE_FORMAT(CURRENT_DATE, '%c.%d') | 1.07 |
| DATE_FORMAT(CURRENT_DATE, '%m.%d') | 01.07 |
| DATE_FORMAT(CURRENT_DATE, '%c.%Y') | 1.2024 |
| DATE_FORMAT(CURRENT_DATE, '%m.%Y') | 01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%c.%y') | 1.24 |
| DATE_FORMAT(CURRENT_DATE, '%m.%y') | 01.24 |
| DATE_FORMAT(CURRENT_DATE, '%c:%Y') | 1:2024 |
| DATE_FORMAT(CURRENT_DATE, '%m:%Y') | 01:2024 |
| DATE_FORMAT(CURRENT_DATE, '%c.%e') | 1.7 |
| DATE_FORMAT(CURRENT_DATE, '%m.%e') | 01.7 |
| DATE_FORMAT(CURRENT_DATE, '%c %e') | 1 7 |
| DATE_FORMAT(CURRENT_DATE, '%m %e') | 01 7 |
| DATE_FORMAT(CURRENT_DATE, '%c %d') | 1 07 |
| DATE_FORMAT(CURRENT_DATE, '%m %d') | 01 07 |
| DATE_FORMAT(CURRENT_DATE, '%c %y') | 1 24 |
| DATE_FORMAT(CURRENT_DATE, '%m %y') | 01 24 |
| DATE_FORMAT(CURRENT_DATE, '%c %e %y') | 1 7 24 |
| DATE_FORMAT(CURRENT_DATE, '%m %e %y') | 01 7 24 |
| DATE_FORMAT(CURRENT_DATE, '%m-%d') | 01-07 |
| DATE_FORMAT(CURRENT_DATE, '%m-%e') | 01-7 |
| DATE_FORMAT(CURRENT_DATE, '%m/%d') | 01/07 |
| DATE_FORMAT(CURRENT_DATE, '%m/%d/%y') | 01/07/24 |
| DATE_FORMAT(CURRENT_DATE, '%m/%e') | 01/7 |
| DATE_FORMAT(CURRENT_DATE, '%b %y') | Jan 24 |
| DATE_FORMAT(CURRENT_DATE, '%c-%y') | 1-24 |
| DATE_FORMAT(CURRENT_DATE, '%c/%y') | 1/24 |
| DATE_FORMAT(CURRENT_DATE, '%m-%y') | 01-24 |
| DATE_FORMAT(CURRENT_DATE, '%m/%y') | 01/24 |
| DATE_FORMAT(CURRENT_DATE, '%d:%c:%y') | 07:1:24 |
| DATE_FORMAT(CURRENT_DATE, '%d:%m:%y') | 07:01:24 |
| DATE_FORMAT(CURRENT_DATE, '%e:%c:%y') | 7:1:24 |
| DATE_FORMAT(CURRENT_DATE, '%e:%m:%y') | 7:01:24 |
| DATE_FORMAT(CURRENT_DATE, '%d:%c:%Y') | 07:1:2024 |
| DATE_FORMAT(CURRENT_DATE, '%d:%m:%Y') | 07:01:2024 |
| DATE_FORMAT(CURRENT_DATE, '%e:%c:%Y') | 7:1:2024 |
| DATE_FORMAT(CURRENT_DATE, '%e:%m:%Y') | 7:01:2024 |
| DATE_FORMAT(CURRENT_DATE, '%j.%Y') | 007.2024 |
| DATE_FORMAT(CURRENT_DATE, '%j.%y') | 007.24 |
| DATE_FORMAT(CURRENT_DATE, '%j%y') | 00724 |
| DATE_FORMAT(CURRENT_DATE, '%d%c%y') | 07124 |
| DATE_FORMAT(CURRENT_DATE, '%e%c%y') | 7124 |
| DATE_FORMAT(CURRENT_DATE, '%d-%b-%y') | 07-Jan-24 |
| DATE_FORMAT(CURRENT_DATE, '%d-%b-%Y') | 07-Jan-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d-%M-%y') | 07-January-24 |
| DATE_FORMAT(CURRENT_DATE, '%d-%M-%Y') | 07-January-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %b %y') | 07 Jan 24 |
| DATE_FORMAT(CURRENT_DATE, '%d %b %Y') | 07 Jan 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %M %y') | 07 January 24 |
| DATE_FORMAT(CURRENT_DATE, '%d %M %Y') | 07 January 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %b %y') | 07 Jan 24 |
| DATE_FORMAT(CURRENT_DATE, '%d %b %Y') | 07 Jan 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %M %y') | 07 January 24 |
| DATE_FORMAT(CURRENT_DATE, '%d %M %Y') | 07 January 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%b/%y') | 07/Jan/24 |
| DATE_FORMAT(CURRENT_DATE, '%d/%b/%Y') | 07/Jan/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%M/%y') | 07/January/24 |
| DATE_FORMAT(CURRENT_DATE, '%d/%M/%Y') | 07/January/2024 |
| DATE_FORMAT(CURRENT_DATE, '%e-%b-%y') | 7-Jan-24 |
| DATE_FORMAT(CURRENT_DATE, '%e-%b-%Y') | 7-Jan-2024 |
| DATE_FORMAT(CURRENT_DATE, '%e-%M-%y') | 7-January-24 |
| DATE_FORMAT(CURRENT_DATE, '%e-%M-%Y') | 7-January-2024 |
| DATE_FORMAT(CURRENT_DATE, '%e %b %y') | 7 Jan 24 |
| DATE_FORMAT(CURRENT_DATE, '%e %b %Y') | 7 Jan 2024 |
| DATE_FORMAT(CURRENT_DATE, '%e %M %y') | 7 January 24 |
| DATE_FORMAT(CURRENT_DATE, '%e %M %Y') | 7 January 2024 |
| DATE_FORMAT(CURRENT_DATE, '%e%b%y') | 7Jan24 |
| DATE_FORMAT(CURRENT_DATE, '%e%b%Y') | 7Jan2024 |
| DATE_FORMAT(CURRENT_DATE, '%e%M%y') | 7January24 |
| DATE_FORMAT(CURRENT_DATE, '%e%M%Y') | 7January2024 |
| DATE_FORMAT(CURRENT_DATE, '%e/%b/%y') | 7/Jan/24 |
| DATE_FORMAT(CURRENT_DATE, '%e/%b/%Y') | 7/Jan/2024 |
| DATE_FORMAT(CURRENT_DATE, '%e/%M/%y') | 7/January/24 |
| DATE_FORMAT(CURRENT_DATE, '%e/%M/%Y') | 7/January/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d-%c-%y') | 07-1-24 |
| DATE_FORMAT(CURRENT_DATE, '%d-%c-%Y') | 07-1-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d-%m-%y') | 07-01-24 |
| DATE_FORMAT(CURRENT_DATE, '%d-%m-%Y') | 07-01-2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%c/%y') | 07/1/24 |
| DATE_FORMAT(CURRENT_DATE, '%d/%c/%Y') | 07/1/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%y') | 07/01/24 |
| DATE_FORMAT(CURRENT_DATE, '%d/%m/%Y') | 07/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%e-%c-%y') | 7-1-24 |
| DATE_FORMAT(CURRENT_DATE, '%e-%c-%Y') | 7-1-2024 |
| DATE_FORMAT(CURRENT_DATE, '%e-%m-%y') | 7-01-24 |
| DATE_FORMAT(CURRENT_DATE, '%e-%m-%Y') | 7-01-2024 |
| DATE_FORMAT(CURRENT_DATE, '%e/%c/%y') | 7/1/24 |
| DATE_FORMAT(CURRENT_DATE, '%e/%c/%Y') | 7/1/2024 |
| DATE_FORMAT(CURRENT_DATE, '%e/%m/%y') | 7/01/24 |
| DATE_FORMAT(CURRENT_DATE, '%e/%m/%Y') | 7/01/2024 |
| DATE_FORMAT(CURRENT_DATE, '%d%m%y') | 070124 |
| DATE_FORMAT(CURRENT_DATE, '%e%m%y') | 70124 |
| DATE_FORMAT(CURRENT_DATE, '%j%Y') | 0072024 |
| DATE_FORMAT(CURRENT_DATE, '%Y%c%e') | 202417 |
| DATE_FORMAT(CURRENT_DATE, '%y%j%e') | 240077 |
| DATE_FORMAT(CURRENT_DATE, '%d%c%Y') | 0712024 |
| DATE_FORMAT(CURRENT_DATE, '%e%c%Y') | 712024 |
| DATE_FORMAT(CURRENT_DATE, '%c%d%Y') | 1072024 |
| DATE_FORMAT(CURRENT_DATE, '%m%d%Y') | 01072024 |
| DATE_FORMAT(CURRENT_DATE, '%Y%j') | 2024007 |
| DATE_FORMAT(CURRENT_DATE, '%Y%m%e') | 2024017 |
| DATE_FORMAT(CURRENT_DATE, '%Y%c%d') | 2024107 |
| DATE_FORMAT(CURRENT_DATE, '%d:%b:%y') | 07:Jan:24 |
| DATE_FORMAT(CURRENT_DATE, '%d:%M:%y') | 07:January:24 |
| DATE_FORMAT(CURRENT_DATE, '%e:%b:%y') | 7:Jan:24 |
| DATE_FORMAT(CURRENT_DATE, '%e:%M:%y') | 7:January:24 |
| DATE_FORMAT(CURRENT_DATE, '%d%m%Y') | 07012024 |
| DATE_FORMAT(CURRENT_DATE, '%e%m%Y') | 7012024 |
| DATE_FORMAT(CURRENT_DATE, '%j %Y') | 007 2024 |
| DATE_FORMAT(CURRENT_DATE, '%j %y') | 007 24 |
| DATE_FORMAT(CURRENT_DATE, '%j/%Y') | 007/2024 |
| DATE_FORMAT(CURRENT_DATE, '%j/%y') | 007/24 |
| DATE_FORMAT(CURRENT_DATE, '%j:%Y') | 007:2024 |
| DATE_FORMAT(CURRENT_DATE, '%j:%y') | 007:24 |
| DATE_FORMAT(CURRENT_DATE, '%j-%Y') | 007-2024 |
| DATE_FORMAT(CURRENT_DATE, '%j-%y') | 007-24 |
| DATE_FORMAT(CURRENT_DATE, '%jth day of %Y') | 007th day of 2024 |
| DATE_FORMAT(CURRENT_DATE, '%m %d') | 01 07 |
| DATE_FORMAT(CURRENT_DATE, '%m %d %Y') | 01 07 2024 |
| DATE_FORMAT(CURRENT_DATE, '%m %d %y') | 01 07 24 |
| DATE_FORMAT(CURRENT_DATE, '%m %Y') | 01 2024 |
| DATE_FORMAT(CURRENT_DATE, '%m %y') | 01 24 |
| DATE_FORMAT(CURRENT_DATE, '%m %e') | 01 7 |
| DATE_FORMAT(CURRENT_DATE, '%m %e %Y') | 01 7 2024 |
| DATE_FORMAT(CURRENT_DATE, '%m %e %y') | 01 7 24 |
| DATE_FORMAT(CURRENT_DATE, '%m.%d.%Y') | 01.07.2024 |
| DATE_FORMAT(CURRENT_DATE, '%m.%d.%y') | 01.07.24 |
| DATE_FORMAT(CURRENT_DATE, '%m.%e.%Y') | 01.7.2024 |
| DATE_FORMAT(CURRENT_DATE, '%m.%e.%y') | 01.7.24 |
| DATE_FORMAT(CURRENT_DATE, '%d %m %Y') | 07 01 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %m %y') | 07 01 24 |
| DATE_FORMAT(CURRENT_DATE, '%d %c %Y') | 07 1 2024 |
| DATE_FORMAT(CURRENT_DATE, '%d %c %y') | 07 1 24 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%Y') | 07.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%m.%y') | 07.01.24 |
| DATE_FORMAT(CURRENT_DATE, '%d.%c.%Y') | 07.1.2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%c.%y') | 07.1.24 |
| DATE_FORMAT(CURRENT_DATE, '%d.%b.%Y') | 07.Jan.2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%b.%y') | 07.Jan.24 |
| DATE_FORMAT(CURRENT_DATE, '%d.%M.%Y') | 07.January.2024 |
| DATE_FORMAT(CURRENT_DATE, '%d.%M.%y') | 07.January.24 |
| DATE_FORMAT(CURRENT_DATE, '%d:%b:%Y') | 07:Jan:2024 |
| DATE_FORMAT(CURRENT_DATE, '%d:%M:%Y') | 07:January:2024 |
| DATE_FORMAT(CURRENT_DATE, '%c %d') | 1 07 |
| DATE_FORMAT(CURRENT_DATE, '%c %d %Y') | 1 07 2024 |
| DATE_FORMAT(CURRENT_DATE, '%c %d %y') | 1 07 24 |
| DATE_FORMAT(CURRENT_DATE, '%c %Y') | 1 2024 |
| DATE_FORMAT(CURRENT_DATE, '%c %y') | 1 24 |
| DATE_FORMAT(CURRENT_DATE, '%c %e') | 1 7 |
| DATE_FORMAT(CURRENT_DATE, '%c %e %Y') | 1 7 2024 |
| DATE_FORMAT(CURRENT_DATE, '%c %e %y') | 1 7 24 |
| DATE_FORMAT(CURRENT_DATE, '%c.%d.%Y') | 1.07.2024 |
| DATE_FORMAT(CURRENT_DATE, '%c.%d.%y') | 1.07.24 |
| DATE_FORMAT(CURRENT_DATE, '%c.%e.%Y') | 1.7.2024 |
| DATE_FORMAT(CURRENT_DATE, '%c.%e.%y') | 1.7.24 |
| DATE_FORMAT(CURRENT_DATE, '%e %m %Y') | 7 01 2024 |
| DATE_FORMAT(CURRENT_DATE, '%e %m %y') | 7 01 24 |
| DATE_FORMAT(CURRENT_DATE, '%e %c %Y') | 7 1 2024 |
| DATE_FORMAT(CURRENT_DATE, '%e %c %y') | 7 1 24 |
| DATE_FORMAT(CURRENT_DATE, '%e.%m.%Y') | 7.01.2024 |
| DATE_FORMAT(CURRENT_DATE, '%e.%m.%y') | 7.01.24 |
| DATE_FORMAT(CURRENT_DATE, '%e.%c.%Y') | 7.1.2024 |
| DATE_FORMAT(CURRENT_DATE, '%e.%c.%y') | 7.1.24 |
| DATE_FORMAT(CURRENT_DATE, '%e.%b.%Y') | 7.Jan.2024 |
| DATE_FORMAT(CURRENT_DATE, '%e.%b.%y') | 7.Jan.24 |
| DATE_FORMAT(CURRENT_DATE, '%e.%M.%Y') | 7.January.2024 |
| DATE_FORMAT(CURRENT_DATE, '%e.%M.%y') | 7.January.24 |
| DATE_FORMAT(CURRENT_DATE, '%e:%b:%Y') | 7:Jan:2024 |
| DATE_FORMAT(CURRENT_DATE, '%e:%M:%Y') | 7:January:2024 |
| DATE_FORMAT(CURRENT_DATE, '%b %D') | Jan 7th |
| DATE_FORMAT(CURRENT_DATE, '%b %D, %Y') | Jan 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%b %D, %y') | Jan 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%b %d') | Jan 07 |
| DATE_FORMAT(CURRENT_DATE, '%b %d, %y') | Jan 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%b %d, %Y') | Jan 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%b %e') | Jan 7 |
| DATE_FORMAT(CURRENT_DATE, '%b %e, %y') | Jan 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%b %e, %Y') | Jan 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%b %Y') | Jan 2024 |
| DATE_FORMAT(CURRENT_DATE, '%M %d, %Y (%jth day)') | January 07, 2024 (007th day) |
| DATE_FORMAT(CURRENT_DATE, '%M %e, %Y (%jth day)') | January 7, 2024 (007th day) |
| DATE_FORMAT(CURRENT_DATE, '%M %D') | January 7th |
| DATE_FORMAT(CURRENT_DATE, '%M %D, %Y') | January 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%M %D, %y') | January 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%M %Y') | January 2024 |
| DATE_FORMAT(CURRENT_DATE, '%M %y') | January 24 |
| DATE_FORMAT(CURRENT_DATE, '%M %d') | January 07 |
| DATE_FORMAT(CURRENT_DATE, '%M %d, %y') | January 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%M %d, %Y') | January 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%M %e') | January 7 |
| DATE_FORMAT(CURRENT_DATE, '%M %e, %y') | January 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%M %e, %Y') | January 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %d, %Y') | Sun Jan 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %d, %y') | Sun Jan 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %e, %Y') | Sun Jan 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %e, %y') | Sun Jan 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %D, %Y') | Sun Jan 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %b %D, %y') | Sun Jan 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %d') | Sun, Jan 07 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %d, %Y') | Sun, Jan 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %d, %y') | Sun, Jan 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %e') | Sun, Jan 7 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %e, %Y') | Sun, Jan 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %e, %y') | Sun, Jan 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %D') | Sun, Jan 7th |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %D, %Y') | Sun, Jan 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %b %D, %y') | Sun, Jan 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %d, %Y') | Sun January 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %d, %y') | Sun January 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %e, %Y') | Sun January 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %e, %y') | Sun January 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %D, %Y') | Sun January 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a %M %D, %y') | Sun January 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %d') | Sun, January 07 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %d, %Y') | Sun, January 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %d, %y') | Sun, January 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %e') | Sun, January 7 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %e, %Y') | Sun, January 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %e, %y') | Sun, January 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %D') | Sun, January 7th |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %D, %Y') | Sun, January 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%a, %M %D, %y') | Sun, January 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %j of %Y') | Sunday 007 of 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %d, %Y') | Sunday Jan 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %d, %y') | Sunday Jan 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %e, %Y') | Sunday Jan 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %e, %y') | Sunday Jan 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %D, %Y') | Sunday Jan 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %b %D, %y') | Sunday Jan 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %d, %Y') | Sunday January 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %d, %y') | Sunday January 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %e, %Y') | Sunday January 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %e, %y') | Sunday January 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %D, %Y') | Sunday January 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W %M %D, %y') | Sunday January 7th, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %d') | Sunday, January 07 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %d, %Y') | Sunday, January 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %d, %y') | Sunday, January 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %e') | Sunday, January 7 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %e, %Y') | Sunday, January 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %e, %y') | Sunday, January 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W, %M %D') | Sunday, January 7th |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %d') | Sunday, Jan 07 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %d, %Y') | Sunday, Jan 07, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %d, %y') | Sunday, Jan 07, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %e') | Sunday, Jan 7 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %e, %Y') | Sunday, Jan 7, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %e, %y') | Sunday, Jan 7, 24 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %D') | Sunday, Jan 7th |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %D, %Y') | Sunday, Jan 7th, 2024 |
| DATE_FORMAT(CURRENT_DATE, '%W, %b %D, %y') | Sunday, Jan 7th, 24 |
| DATE '2024-12-31' | 2024-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y') -- 4-digit year | 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%y') -- Last 2 digits of year | 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c') -- %c - Numeric month name (0 to 12) | 12 |
| DATE_FORMAT(DATE '2024-12-31', '%m') -- %m - Month name as a numeric value (00 to 12) | 12 |
| DATE_FORMAT(DATE '2024-12-31', '%b') -- %b - Abbreviated month name (Jan to Dec) | Dec |
| DATE_FORMAT(DATE '2024-12-31', '%M') -- %M - Month name in full (January to December) | December |
| DATE_FORMAT(DATE '2024-12-31', '%U') -- %U - Week where Sunday is the first day of the week (00 to 53) | 52 |
| DATE_FORMAT(DATE '2024-12-31', '%u') -- %u - Week where day is the first day of the week (00 to 53) | 53 |
| DATE_FORMAT(DATE '2024-12-31', '%V') -- %V - Week where Sunday is the first day of the week (01 to 53). Used with %X | 52 |
| DATE_FORMAT(DATE '2024-12-31', '%v') -- %v - Week where %bday is the first day of the week (01 to 53). Used with %x | 01 |
| DATE_FORMAT(DATE '2024-12-31', '%X') -- %X - Year for the week where Sunday is the first day of the week. Used with %V | 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%x') -- %x - Year for the week where %bday is the first day of the week. Used with %v | 2025 |
| DATE_FORMAT(DATE '2024-12-31', '%a') -- %a - Abbreviated weekday name (Sun to Sat) | Tue |
| DATE_FORMAT(DATE '2024-12-31', '%W') -- %W - Weekday name in full (Sunday to Saturday) | Tuesday |
| DATE_FORMAT(DATE '2024-12-31', '%w') -- %w - %W of the week where Sunday=0 and Saturday=6 | 2 |
| DATE_FORMAT(DATE '2024-12-31', '%j') -- %j - %W of the year (001 to 366) | 366 |
| DATE_FORMAT(DATE '2024-12-31', '%d') -- %d - %W of the month as a numeric value (01 to 31) | 31 |
| DATE_FORMAT(DATE '2024-12-31', '%e') -- %e - month as a numeric value (0 to 31) | 31 |
| DATE_FORMAT(DATE '2024-12-31', '%D') -- %D - %W of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...) | 31st |
| DATE_FORMAT(DATE '2024-12-31', '%h') -- %h - Hour (00 to 12) | 12 |
| DATE_FORMAT(DATE '2024-12-31', '%I') -- %I -Hour (00 to 12) | 12 |
| DATE_FORMAT(DATE '2024-12-31', '%H') -- %H - Hour (00 to 23) | 00 |
| DATE_FORMAT(DATE '2024-12-31', '%k') -- %k - Hour (0 to 23) | 0 |
| DATE_FORMAT(DATE '2024-12-31', '%l') -- %l - Hour (1 to 12) | 12 |
| DATE_FORMAT(DATE '2024-12-31', '%r') -- %r - Time in 12 hour AM or PM FORMAT (hh:mm:ss AM/PM) | 12:00:00 AM |
| DATE_FORMAT(DATE '2024-12-31', '%i') -- %i - Minutes (00 to 59) | 00 |
| DATE_FORMAT(DATE '2024-12-31', '%S') -- %S - Seconds (00 to 59) | 00 |
| DATE_FORMAT(DATE '2024-12-31', '%s') -- %s - Seconds (00 to 59) | 00 |
| DATE_FORMAT(DATE '2024-12-31', '%T') -- %T - Time in 24 hour FORMAT (hh:mm:ss) | 00:00:00 |
| DATE_FORMAT(DATE '2024-12-31', '%f') -- %f - Microseconds (000000 to 999999) | 000000 |
| DATE_FORMAT(DATE '2024-12-31', '%p') -- %p - AM or PM | AM |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%m-%d') | 2024-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%m-%e') | 2024-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%c-%e') | 2024-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%c-%d') | 2024-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%m/%d') | 2024/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%c/%e') | 2024/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%c/%d') | 2024/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%c:%d') | 2024:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%m:%e') | 2024:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%c:%e') | 2024:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%c.%d') | 2024.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%m.%e') | 2024.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%c.%e') | 2024.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %c %d') | 2024 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %c %e') | 2024 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %j') | 2024 366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%j.%e') | 2024.366.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%b.%e') | 2024.Dec.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%M.%e') | 2024.December.31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%j') | 2024/366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%j/%e') | 2024/366/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%b/%e') | 2024/Dec/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y/%M/%e') | 2024/December/31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%j') | 2024:366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%j:%e') | 2024:366:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%b:%e') | 2024:Dec:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y:%M:%e') | 2024:December:31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%j') | 2024-366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%j-%e') | 2024-366-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%c') | 2024-12 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%b%e') | 2024Dec31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%b-%e') | 2024-Dec-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%M%e') | 2024December31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y-%M-%e') | 2024-December-31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %j %e') | 2024 366 31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %j%e') | 2024 36631 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %m %e') | 2024 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %b %e') | 2024 Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%Y %M %e') | 2024 December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%m-%d') | 24-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%m/%d') | 24/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y %j') | 24 366 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%j.%e') | 24.366.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%m.%e') | 24.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%c.%d') | 24.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%c.%e') | 24.12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%b.%e') | 24.Dec.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%M.%e') | 24.December.31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%j') | 24/366 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%j/%e') | 24/366/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%m/%e') | 24/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%c/%d') | 24/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%c/%e') | 24/12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%j') | 24:366 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%j:%e') | 24:366:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%b:%e') | 24:Dec:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%M:%e') | 24:December:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%j') | 24-366 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%j-%e') | 24-366-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%m-%e') | 24-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%c-%d') | 24-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%c-%e') | 24-12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%m:%e') | 24:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%c:%e') | 24:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y:%c:%d') | 24:12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%y.%j') | 24.366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y.%j') | 2024.366 |
| DATE_FORMAT(DATE '2024-12-31', '%y%c%e') | 241231 |
| DATE_FORMAT(DATE '2024-12-31', '%y%j') | 24366 |
| DATE_FORMAT(DATE '2024-12-31', '%y%m%e') | 241231 |
| DATE_FORMAT(DATE '2024-12-31', '%y%c%d') | 241231 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%M/%e') | 24/December/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y/%b/%e') | 24/Dec/31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%M-%e') | 24-December-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y%M%e') | 24December31 |
| DATE_FORMAT(DATE '2024-12-31', '%y-%b-%e') | 24-Dec-31 |
| DATE_FORMAT(DATE '2024-12-31', '%y%b%e') | 24Dec31 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%d-%y') | 12-31-24 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%d-%Y') | 12-31-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%e-%y') | 12-31-24 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%e-%Y') | 12-31-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%d-%y') | 12-31-24 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%d-%Y') | 12-31-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%e-%y') | 12-31-24 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%e-%Y') | 12-31-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%d/%y') | 12/31/24 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%d/%Y') | 12/31/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%e/%y') | 12/31/24 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%e/%Y') | 12/31/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%e/%y') | 12/31/24 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%e/%Y') | 12/31/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%d:%y') | 12:31:24 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%e:%y') | 12:31:24 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%d:%y') | 12:31:24 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%e:%y') | 12:31:24 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%d:%Y') | 12:31:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%e:%Y') | 12:31:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%d:%Y') | 12:31:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%e:%Y') | 12:31:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c%e%Y') | 12312024 |
| DATE_FORMAT(DATE '2024-12-31', '%m%e%Y') | 12312024 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%e') | 12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%d') | 12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%c%d%y') | 123124 |
| DATE_FORMAT(DATE '2024-12-31', '%m%d%y') | 123124 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%Y') | 12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%Y') | 12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%Y') | 12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%Y') | 12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c%Y') | 122024 |
| DATE_FORMAT(DATE '2024-12-31', '%m%Y') | 122024 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%d') | 12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%e') | 12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%d') | 12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%e') | 12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%d') | 12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%e') | 12:31 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%y') | 12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%y') | 12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%d') | 12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%d') | 12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%Y') | 12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%Y') | 12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%y') | 12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%y') | 12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%c:%Y') | 12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m:%Y') | 12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%e') | 12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%e') | 12.31 |
| DATE_FORMAT(DATE '2024-12-31', '%c %e') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%m %e') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%c %d') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%m %d') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%c %y') | 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m %y') | 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c %e %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m %e %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%d') | 12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%e') | 12-31 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%d') | 12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%d/%y') | 12/31/24 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%e') | 12/31 |
| DATE_FORMAT(DATE '2024-12-31', '%b %y') | Dec 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c-%y') | 12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%c/%y') | 12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%m-%y') | 12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%m/%y') | 12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%c:%y') | 31:12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%m:%y') | 31:12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%c:%y') | 31:12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%m:%y') | 31:12:24 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%c:%Y') | 31:12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%m:%Y') | 31:12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%c:%Y') | 31:12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%m:%Y') | 31:12:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j.%Y') | 366.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j.%y') | 366.24 |
| DATE_FORMAT(DATE '2024-12-31', '%j%y') | 36624 |
| DATE_FORMAT(DATE '2024-12-31', '%d%c%y') | 311224 |
| DATE_FORMAT(DATE '2024-12-31', '%e%c%y') | 311224 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%b-%y') | 31-Dec-24 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%b-%Y') | 31-Dec-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%M-%y') | 31-December-24 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%M-%Y') | 31-December-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %b %y') | 31 Dec 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %b %Y') | 31 Dec 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %M %y') | 31 December 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %M %Y') | 31 December 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %b %y') | 31 Dec 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %b %Y') | 31 Dec 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %M %y') | 31 December 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %M %Y') | 31 December 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%b/%y') | 31/Dec/24 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%b/%Y') | 31/Dec/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%M/%y') | 31/December/24 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%M/%Y') | 31/December/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%b-%y') | 31-Dec-24 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%b-%Y') | 31-Dec-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%M-%y') | 31-December-24 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%M-%Y') | 31-December-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e %b %y') | 31 Dec 24 |
| DATE_FORMAT(DATE '2024-12-31', '%e %b %Y') | 31 Dec 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e %M %y') | 31 December 24 |
| DATE_FORMAT(DATE '2024-12-31', '%e %M %Y') | 31 December 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e%b%y') | 31Dec24 |
| DATE_FORMAT(DATE '2024-12-31', '%e%b%Y') | 31Dec2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e%M%y') | 31December24 |
| DATE_FORMAT(DATE '2024-12-31', '%e%M%Y') | 31December2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%b/%y') | 31/Dec/24 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%b/%Y') | 31/Dec/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%M/%y') | 31/December/24 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%M/%Y') | 31/December/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%c-%y') | 31-12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%c-%Y') | 31-12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%m-%y') | 31-12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%d-%m-%Y') | 31-12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%c/%y') | 31/12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%c/%Y') | 31/12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%m/%y') | 31/12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%d/%m/%Y') | 31/12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%c-%y') | 31-12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%c-%Y') | 31-12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%m-%y') | 31-12-24 |
| DATE_FORMAT(DATE '2024-12-31', '%e-%m-%Y') | 31-12-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%c/%y') | 31/12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%c/%Y') | 31/12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%m/%y') | 31/12/24 |
| DATE_FORMAT(DATE '2024-12-31', '%e/%m/%Y') | 31/12/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d%m%y') | 311224 |
| DATE_FORMAT(DATE '2024-12-31', '%e%m%y') | 311224 |
| DATE_FORMAT(DATE '2024-12-31', '%j%Y') | 3662024 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%c%e') | 20241231 |
| DATE_FORMAT(DATE '2024-12-31', '%y%j%e') | 2436631 |
| DATE_FORMAT(DATE '2024-12-31', '%d%c%Y') | 31122024 |
| DATE_FORMAT(DATE '2024-12-31', '%e%c%Y') | 31122024 |
| DATE_FORMAT(DATE '2024-12-31', '%c%d%Y') | 12312024 |
| DATE_FORMAT(DATE '2024-12-31', '%m%d%Y') | 12312024 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%j') | 2024366 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%m%e') | 20241231 |
| DATE_FORMAT(DATE '2024-12-31', '%Y%c%d') | 20241231 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%b:%y') | 31:Dec:24 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%M:%y') | 31:December:24 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%b:%y') | 31:Dec:24 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%M:%y') | 31:December:24 |
| DATE_FORMAT(DATE '2024-12-31', '%d%m%Y') | 31122024 |
| DATE_FORMAT(DATE '2024-12-31', '%e%m%Y') | 31122024 |
| DATE_FORMAT(DATE '2024-12-31', '%j %Y') | 366 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j %y') | 366 24 |
| DATE_FORMAT(DATE '2024-12-31', '%j/%Y') | 366/2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j/%y') | 366/24 |
| DATE_FORMAT(DATE '2024-12-31', '%j:%Y') | 366:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j:%y') | 366:24 |
| DATE_FORMAT(DATE '2024-12-31', '%j-%Y') | 366-2024 |
| DATE_FORMAT(DATE '2024-12-31', '%j-%y') | 366-24 |
| DATE_FORMAT(DATE '2024-12-31', '%jth day of %Y') | 366th day of 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m %d') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%m %d %Y') | 12 31 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m %d %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m %Y') | 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m %y') | 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m %e') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%m %e %Y') | 12 31 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m %e %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%d.%Y') | 12.31.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%d.%y') | 12.31.24 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%e.%Y') | 12.31.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%m.%e.%y') | 12.31.24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %m %Y') | 31 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %m %y') | 31 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d %c %Y') | 31 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d %c %y') | 31 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%m.%Y') | 31.12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%m.%y') | 31.12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%c.%Y') | 31.12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%c.%y') | 31.12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%b.%Y') | 31.Dec.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%b.%y') | 31.Dec.24 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%M.%Y') | 31.December.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d.%M.%y') | 31.December.24 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%b:%Y') | 31:Dec:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%d:%M:%Y') | 31:December:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c %d') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%c %d %Y') | 12 31 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c %d %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c %Y') | 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c %y') | 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c %e') | 12 31 |
| DATE_FORMAT(DATE '2024-12-31', '%c %e %Y') | 12 31 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c %e %y') | 12 31 24 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%d.%Y') | 12.31.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%d.%y') | 12.31.24 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%e.%Y') | 12.31.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%c.%e.%y') | 12.31.24 |
| DATE_FORMAT(DATE '2024-12-31', '%e %m %Y') | 31 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e %m %y') | 31 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%e %c %Y') | 31 12 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e %c %y') | 31 12 24 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%m.%Y') | 31.12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%m.%y') | 31.12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%c.%Y') | 31.12.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%c.%y') | 31.12.24 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%b.%Y') | 31.Dec.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%b.%y') | 31.Dec.24 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%M.%Y') | 31.December.2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e.%M.%y') | 31.December.24 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%b:%Y') | 31:Dec:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%e:%M:%Y') | 31:December:2024 |
| DATE_FORMAT(DATE '2024-12-31', '%b %D') | Dec 31st |
| DATE_FORMAT(DATE '2024-12-31', '%b %D, %Y') | Dec 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%b %D, %y') | Dec 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%b %d') | Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%b %d, %y') | Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%b %d, %Y') | Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%b %e') | Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%b %e, %y') | Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%b %e, %Y') | Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%b %Y') | Dec 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%M %d, %Y (%jth day)') | December 31, 2024 (366th day) |
| DATE_FORMAT(DATE '2024-12-31', '%M %e, %Y (%jth day)') | December 31, 2024 (366th day) |
| DATE_FORMAT(DATE '2024-12-31', '%M %D') | December 31st |
| DATE_FORMAT(DATE '2024-12-31', '%M %D, %Y') | December 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%M %D, %y') | December 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%M %Y') | December 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%M %y') | December 24 |
| DATE_FORMAT(DATE '2024-12-31', '%M %d') | December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%M %d, %y') | December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%M %d, %Y') | December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%M %e') | December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%M %e, %y') | December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%M %e, %Y') | December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %d, %Y') | Tue Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %d, %y') | Tue Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %e, %Y') | Tue Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %e, %y') | Tue Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %D, %Y') | Tue Dec 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %b %D, %y') | Tue Dec 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %d') | Tue, Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %d, %Y') | Tue, Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %d, %y') | Tue, Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %e') | Tue, Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %e, %Y') | Tue, Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %e, %y') | Tue, Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %D') | Tue, Dec 31st |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %D, %Y') | Tue, Dec 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %b %D, %y') | Tue, Dec 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %d, %Y') | Tue December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %d, %y') | Tue December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %e, %Y') | Tue December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %e, %y') | Tue December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %D, %Y') | Tue December 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a %M %D, %y') | Tue December 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %d') | Tue, December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %d, %Y') | Tue, December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %d, %y') | Tue, December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %e') | Tue, December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %e, %Y') | Tue, December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %e, %y') | Tue, December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %D') | Tue, December 31st |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %D, %Y') | Tue, December 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%a, %M %D, %y') | Tue, December 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %j of %Y') | Tuesday 366 of 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %d, %Y') | Tuesday Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %d, %y') | Tuesday Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %e, %Y') | Tuesday Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %e, %y') | Tuesday Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %D, %Y') | Tuesday Dec 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %b %D, %y') | Tuesday Dec 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %d, %Y') | Tuesday December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %d, %y') | Tuesday December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %e, %Y') | Tuesday December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %e, %y') | Tuesday December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %D, %Y') | Tuesday December 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W %M %D, %y') | Tuesday December 31st, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %d') | Tuesday, December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %d, %Y') | Tuesday, December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %d, %y') | Tuesday, December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %e') | Tuesday, December 31 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %e, %Y') | Tuesday, December 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %e, %y') | Tuesday, December 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %M %D') | Tuesday, December 31st |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %d') | Tuesday, Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %d, %Y') | Tuesday, Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %d, %y') | Tuesday, Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %e') | Tuesday, Dec 31 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %e, %Y') | Tuesday, Dec 31, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %e, %y') | Tuesday, Dec 31, 24 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %D') | Tuesday, Dec 31st |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %D, %Y') | Tuesday, Dec 31st, 2024 |
| DATE_FORMAT(DATE '2024-12-31', '%W, %b %D, %y') | Tuesday, Dec 31st, 24 |
| CURRENT_TIMESTAMP | 2024-01-07 07:44:43.000000 |