Formatting Teradata Dates
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 Teradata? Teradata uses two ways to format dates: the FORMAT statement and the TO_CHAR function. This blog will brilliantly break down and explain everything about both, so you will easily format a Teradata date in any way you desire.
Teradata uses the TO_CHAR command to transform raw date or timestamp data to format it as you want it presented.
I will start with the basics, give you all the elements so you can put together the format you want, give you a table with the most popular formats per industry in the United States, and finally, provide you with a table that has 300 examples.
Below is a picture of two queries to see the syntax of the FORMAT statement and the TO_CHAR function.
I bet you didn’t know you can use FORMAT and TO_CHAR to filter rows in the WHERE clause. The next two pictures are where it gets interesting because we will demonstrate how to use FORMAT and TO_CHAR to filter rows. I have two examples that show you how.
Below is a table to show you the elements or components you can use to format a date using the FORMAT command.
| Syntax | Desired_Output |
|---|---|
| SELECT CURRENT_DATE | 2024-01-20 |
| CURRENT_DATE (FORMAT 'YYYY') AS YYYY | 2024 |
| CURRENT_DATE (FORMAT 'Y4') AS Y4 | 2024 |
| CURRENT_DATE (FORMAT 'YY') AS YY | 24 |
| CURRENT_DATE (FORMAT 'MMMM') AS MMMM | January |
| CURRENT_DATE (FORMAT 'MMM') AS MMM | Jan |
| CURRENT_DATE (FORMAT 'M3') AS M3 | Jan |
| CURRENT_DATE (FORMAT 'M4') AS M4 | January |
| CURRENT_DATE (FORMAT 'DD') AS DD | 20 |
| CURRENT_DATE (FORMAT 'DDD') AS DDD | 020 |
| CURRENT_DATE (FORMAT 'E3') AS E3 | Sat |
| CURRENT_DATE (FORMAT 'EEE') AS EEE | Sat |
| CURRENT_DATE (FORMAT 'E4') AS E4 | Saturday |
| CURRENT_DATE (FORMAT 'EEEE') AS EEEE | Saturday |
| CURRENT_DATE (FORMAT 'MMMMDD') AS MMMMDD | January20 |
| CURRENT_DATE (FORMAT 'MMMMbDD') AS MMMMbDD | January 20 |
Below is a table to show you the elements or components you can use to format a date using the TO_CHAR function.
| Syntax | Desired_Output |
|---|---|
| CURRENT_DATE | 2024-01-20 |
| TO_CHAR(CURRENT_DATE, 'YYYY') AS YY | 2024 |
| TO_CHAR(CURRENT_DATE, 'MM') AS MM | 01 |
| TO_CHAR(CURRENT_DATE, 'DD') AS DD | 20 |
| TO_CHAR(CURRENT_DATE, 'MONTH') AS MONTH | JANUARY |
| TO_CHAR(CURRENT_DATE, 'FMMonth') AS FMMonth | January |
| TO_CHAR(CURRENT_DATE, 'Month') AS Month2 | January |
| TO_CHAR(CURRENT_DATE, 'month') AS month3 | january |
| TO_CHAR(CURRENT_DATE, 'MON') AS MON | JAN |
| TO_CHAR(CURRENT_DATE, 'Mon') AS Mon2 | Jan |
| TO_CHAR(CURRENT_DATE, 'mon') AS mon3 | jan |
| TO_CHAR(CURRENT_DATE, 'YEAR') AS YEAR | TWENTY TWENTY-FOUR |
| TO_CHAR(CURRENT_DATE, 'Year') AS Year2 | Twenty Twenty-Four |
| TO_CHAR(CURRENT_DATE, 'year') AS year3 | twenty twenty-four |
| TO_CHAR(CURRENT_DATE, 'DDD') AS DDD | 020 |
| TO_CHAR(CURRENT_DATE, 'DDDth') AS DDDth | 020TH |
| TO_CHAR(CURRENT_DATE, 'Q') AS Q | 1 |
| TO_CHAR(CURRENT_DATE, 'HH') AS HH | 12 |
| TO_CHAR(CURRENT_DATE, 'HH12') AS HH12 | 12 |
| TO_CHAR(CURRENT_DATE, 'HH24') AS HH24 | 00 |
| TO_CHAR(CURRENT_DATE, 'MI') AS MI | 00 |
| TO_CHAR(CURRENT_DATE, 'SS') AS SS1 | 00 |
| TO_CHAR(CURRENT_DATE, 'DAY') AS DAY | SATURDAY |
| TO_CHAR(CURRENT_DATE, 'Day') AS Day2 | Saturday |
| TO_CHAR(CURRENT_DATE, 'day') AS day3 | saturday |
| TO_CHAR(CURRENT_DATE, 'DY') AS DY | SAT |
| TO_CHAR(CURRENT_DATE, 'Dy') AS Dy2 | Sat |
| TO_CHAR(CURRENT_DATE, 'dy') AS dy3 | sat |
| TO_CHAR(CURRENT_DATE, 'AM') AS AM | AM |
| TO_CHAR(CURRENT_DATE, 'PM') AS PM | AM |
| TO_CHAR(CURRENT_DATE, 'WW') AS ISO_WEEK_NUMBER | 03 |
| TO_CHAR(CURRENT_DATE, 'IYYY') AS ISO_YEAR | 2024 |
| TO_CHAR(CURRENT_DATE, 'IW') AS ISO_WEEK_OF_YEAR | 03 |
Below is a table with the most popular formats per industry in the United States.
| SYNTAX | DESIRED OUTPUT |
|---|---|
| SELECT CURRENT_DATE AS TODAYS_DATE, | 2024-01-20 |
| CURRENT_DATE (FORMAT 'MM/DD/YYYY') AS US_SHORT_DATE, | 01/20/2024 |
| TO_CHAR(CURRENT_DATE, 'MM/DD/YYYY') AS US_SHORT_DATE2, | 01/20/2024 |
| CURRENT_DATE (FORMAT 'MMMM DD, YYYY') AS US_LONG_DATE, | January20,2024 |
| TO_CHAR(CURRENT_DATE, 'Month DD, YYYY') AS US_LONG_DATE2, | January 20, 2024 |
| CURRENT_DATE (FORMAT 'YYYY-MM-DD') AS FINANCIAL_FORMAT, | 2024-01-20 |
| TO_CHAR(CURRENT_DATE, 'YYYY/MM/DD') AS FINANCIAL_FORMAT2, | 2024/01/20 |
| CURRENT_DATE (FORMAT 'MM/DD/YYYY') AS HEALTHCARE_FORMAT, | 01/20/2024 |
| TO_CHAR(CURRENT_DATE, 'YYYY/MM/DD') AS HEALTHCARE_FORMAT2, | 2024/01/20 |
| CURRENT_DATE (FORMAT 'YYYY-MM-DD') AS LEGAL_FORMAT, | 2024-01-20 |
| TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY') AS LEGAL_FORMAT2, | 20/01/2024 |
| CURRENT_DATE (FORMAT 'MM.DD.YYYY') AS MANUFACTURING_FORMAT, | 01.20.2024 |
| TO_CHAR(CURRENT_DATE, 'DD-MM-YYYY') AS MANUFACTURING_FORMAT2, | 20-01-2024 |
| TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD HH24:MI:SS') AS TECH_LONG_DATE_TIME, | 2024-01-20 00:00:00 |
| CURRENT_DATE (FORMAT 'DD-MMM-YYYY') AS EDUCATION_FORMAT, | 20-Jan-2024 |
| TO_CHAR(CURRENT_DATE, 'Month DD, YYYY') AS EDUCATION_FORMAT2, | January 20, 2024 |
| CURRENT_DATE (FORMAT 'YYYYMMDD') AS RETAIL_FORMAT, | 20240120 |
| TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY') AS RETAIL_FORMAT2, | 20/01/2024 |
| CURRENT_DATE (FORMAT 'YYYY-MMM-DD') AS REAL_ESTATE_FORMAT, | 2024-Jan-20 |
| TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY') AS REAL_ESTATE_FORMAT2, | 20/01/2024 |
| CURRENT_DATE (FORMAT 'MM/DD/YYYY') AS HOSPITALITY_FORMAT, | 01/20/2024 |
| TO_CHAR(CURRENT_DATE, 'Month DD, YYYY HH:MI AM') AS HOSPITALITY_FORMAT2, | January 20, 2024 12:00 AM |
| TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD HH24:MI:SS') AS TRANSPORTATION_FORMAT, | 2024-01-20 00:00:00 |
| TO_CHAR(CURRENT_DATE, 'DD.MM.YYYY') AS TRANSPORTATION_FORMAT2, | 20.01.2024 |
| CURRENT_DATE (FORMAT 'YYYY-MM-DD') AS ENERGY_FORMAT, | 2024-01-20 |
| TO_CHAR(CURRENT_DATE, 'YYYY/MM/DD') AS ENERGY_FORMAT2 | 2024/01/20 |
Here is a table that has 300 examples using the CURRENT_DATE and a literal date of DATE ‘2024-12-31’ with the FORMAT statements and TO_CHAR function.
| SYNTAX | DESIRED OUTPUT |
|---|---|
| SELECT CURRENT_DATE | 2024-01-20 12:00:00 -05:00 |
| ,CURRENT_DATE (FORMAT 'YYYY') | 2024 |
| ,CURRENT_DATE (FORMAT 'Y4') | 2024 |
| ,CURRENT_DATE (FORMAT 'YY') | 24 |
| ,CURRENT_DATE (FORMAT 'MMMM') | January |
| ,CURRENT_DATE (FORMAT 'MMM') | Jan |
| ,CURRENT_DATE (FORMAT 'M3') | Jan |
| ,CURRENT_DATE (FORMAT 'M4') | January |
| ,CURRENT_DATE (FORMAT 'DD') | 20 |
| ,CURRENT_DATE (FORMAT 'DDD') | 020 |
| ,CURRENT_DATE (FORMAT 'E3') | Sat |
| ,CURRENT_DATE (FORMAT 'EEE') | Sat |
| ,CURRENT_DATE (FORMAT 'E4') | Saturday |
| ,CURRENT_DATE (FORMAT 'EEEE') | Saturday |
| ,CURRENT_DATE (FORMAT 'MMMMDD') | January20 |
| ,CURRENT_DATE (FORMAT 'MMMMbDD') | January 20 |
| ,CURRENT_DATE (FORMAT 'YYYY/MM/DD') | 2024/01/20 |
| ,CURRENT_DATE (FORMAT 'Y4/MM/DD') | 2024/01/20 |
| ,CURRENT_DATE (FORMAT 'YYYY-MM-DD') | 2024-01-20 |
| ,CURRENT_DATE (FORMAT 'Y4-MM-DD') | 2024-01-20 |
| ,CURRENT_DATE (FORMAT 'YY/MM/DD') | 24/01/20 |
| ,CURRENT_DATE (FORMAT 'YY-MM-DD') | 24-01-20 |
| ,CURRENT_DATE (FORMAT 'YYYYb MMMMb DD') | 2024 January 20 |
| ,CURRENT_DATE (FORMAT 'YYYYDDD') | 2024020 |
| ,CURRENT_DATE (FORMAT 'YYYY.DDD') | 2024.020 |
| ,CURRENT_DATE (FORMAT 'YYYY:MM:DD') | 2024:01:20 |
| ,CURRENT_DATE (FORMAT 'MM/DD/YYYY') | 01/20/2024 |
| ,CURRENT_DATE (FORMAT 'MM-DD-YYYY') | 01-20-2024 |
| ,CURRENT_DATE (FORMAT 'MMMMb DD,b YYYY') | January 20, 2024 |
| ,CURRENT_DATE (FORMAT 'MM-DD-YY') | 01-20-24 |
| ,CURRENT_DATE (FORMAT 'MMM-DD-YYYY') | Jan-20-2024 |
| ,CURRENT_DATE (FORMAT 'M3-DD-YYYY') | Jan-20-2024 |
| ,CURRENT_DATE (FORMAT 'MMMM-DD-YYYY') | January-20-2024 |
| ,CURRENT_DATE (FORMAT 'M4-DD-YYYY') | January-20-2024 |
| ,CURRENT_DATE (FORMAT 'MM-DDD-YYYY') | 01-020-2024 |
| ,CURRENT_DATE (FORMAT 'MM-D3-YYYY') | 01-020-2024 |
| ,CURRENT_DATE (FORMAT 'MM-YY') | 01-24 |
| ,CURRENT_DATE (FORMAT 'DD/MM/YYYY') | 20/01/2024 |
| ,CURRENT_DATE (FORMAT 'DD-MM-YYYY') | 20-01-2024 |
| ,CURRENT_DATE (FORMAT 'DD bMMMM bYYYY') | 20 January 2024 |
| ,CURRENT_DATE (FORMAT 'EEE-MM-DDD-YYYY') | Sat-01-020-2024 |
| ,CURRENT_DATE (FORMAT 'E3-MM-DDD-YYYY') | Sat-01-020-2024 |
| ,CURRENT_DATE (FORMAT 'EEEE-MM-DDD-YYYY') | Saturday-01-020-2024 |
| ,CURRENT_DATE (FORMAT 'E4-MM-DDD-YYYY') | Saturday-01-020-2024 |
| ,CURRENT_DATE (FORMAT 'EEE') | Sat |
| ,CURRENT_DATE (FORMAT 'E3') | Sat |
| ,CURRENT_DATE (FORMAT 'EEEE') | Saturday |
| ,CURRENT_DATE (FORMAT 'E4') | Saturday |
| ,CURRENT_DATE (FORMAT 'EEEE,b DDb MMMMb YYYY') | Saturday, 20 January 2024 |
| ,DATE '2024-12-31' (FORMAT 'YYYY/MM/DD') | 2024/12/31 |
| ,DATE '2024-12-31' (FORMAT 'Y4/MM/DD') | 2024/12/31 |
| ,DATE '2024-12-31' (FORMAT 'YYYY-MM-DD') | 2024-12-31 |
| ,DATE '2024-12-31' (FORMAT 'Y4-MM-DD') | 2024-12-31 |
| ,DATE '2024-12-31' (FORMAT 'YY/MM/DD') | 24/12/31 |
| ,DATE '2024-12-31' (FORMAT 'YY-MM-DD') | 24-12-31 |
| ,DATE '2024-12-31' (FORMAT 'YYYYb MMMMb DD') | 2024 December 31 |
| ,DATE '2024-12-31' (FORMAT 'YYYY.DDD') | 2024.366 |
| ,DATE '2024-12-31' (FORMAT 'YYYY:MM:DD') | 2024:12:31 |
| ,DATE '2024-12-31' (FORMAT 'YYYYDDD') | 2024366 |
| ,DATE '2024-12-31' (FORMAT 'MM/DD/YYYY') | 12/31/2024 |
| ,DATE '2024-12-31' (FORMAT 'MM-DD-YYYY') | 12-31-2024 |
| ,DATE '2024-12-31' (FORMAT 'MMMMb DD,b YYYY') | December 31, 2024 |
| ,DATE '2024-12-31' (FORMAT 'MM-DD-YY') | 12-31-24 |
| ,DATE '2024-12-31' (FORMAT 'MMM-DD-YYYY') | Dec-31-2024 |
| ,DATE '2024-12-31' (FORMAT 'M3-DD-YYYY') | Dec-31-2024 |
| ,DATE '2024-12-31' (FORMAT 'MMMM-DD-YYYY') | December-31-2024 |
| ,DATE '2024-12-31' (FORMAT 'M4-DD-YYYY') | December-31-2024 |
| ,DATE '2024-12-31' (FORMAT 'MM-DDD-YYYY') | 12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'MM-D3-YYYY') | 12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'MM-YY') | 12-24 |
| ,DATE '2024-12-31' (FORMAT 'DD/MM/YYYY') | 31/12/2024 |
| ,DATE '2024-12-31' (FORMAT 'DD-MM-YYYY') | 31-12-2024 |
| ,DATE '2024-12-31' (FORMAT 'DD bMMMM bYYYY') | 31 December 2024 |
| ,DATE '2024-12-31' (FORMAT 'EEEE,b DDb MMMMb YYYY') | Tuesday, 31 December 2024 |
| ,DATE '2024-12-31' (FORMAT 'EEE-MM-DDD-YYYY') | Tue-12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'E3-MM-DDD-YYYY') | Tue-12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'EEEE-MM-DDD-YYYY') | Tuesday-12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'E4-MM-DDD-YYYY') | Tuesday-12-366-2024 |
| ,DATE '2024-12-31' (FORMAT 'EEE') | Tue |
| ,DATE '2024-12-31' (FORMAT 'E3') | Tue |
| ,DATE '2024-12-31' (FORMAT 'EEEE') | Tuesday |
| ,DATE '2024-12-31' (FORMAT 'E4') | Tuesday |
| ,TO_CHAR(CURRENT_DATE, 'YYYY') | 2024 |
| ,TO_CHAR(CURRENT_DATE, 'MM') | 01 |
| ,TO_CHAR(CURRENT_DATE, 'DD') | 20 |
| ,TO_CHAR(CURRENT_DATE, 'MONTH') | JANUARY |
| ,TO_CHAR(CURRENT_DATE, 'FMMonth') | January |
| ,TO_CHAR(CURRENT_DATE, 'Month') | January |
| ,TO_CHAR(CURRENT_DATE, 'month') | january |
| ,TO_CHAR(CURRENT_DATE, 'MON') | JAN |
| ,TO_CHAR(CURRENT_DATE, 'Mon') | Jan |
| ,TO_CHAR(CURRENT_DATE, 'mon') | jan |
| ,TO_CHAR(CURRENT_DATE, 'YEAR') | TWENTY TWENTY-FOUR |
| ,TO_CHAR(CURRENT_DATE, 'Year') | Twenty Twenty-Four |
| ,TO_CHAR(CURRENT_DATE, 'year') | twenty twenty-four |
| ,TO_CHAR(CURRENT_DATE, 'DDD') | 020 |
| ,TO_CHAR(CURRENT_DATE, 'DDDth') A | 020TH |
| ,TO_CHAR(CURRENT_DATE, 'Q') | 1 |
| ,TO_CHAR(CURRENT_DATE, 'HH') | 12 |
| ,TO_CHAR(CURRENT_DATE, 'HH12') | 12 |
| ,TO_CHAR(CURRENT_DATE, 'HH24') | 00 |
| ,TO_CHAR(CURRENT_DATE, 'MI') | 00 |
| ,TO_CHAR(CURRENT_DATE, 'SS') | 00 |
| ,TO_CHAR(CURRENT_DATE, 'DAY') | SATURDAY |
| ,TO_CHAR(CURRENT_DATE, 'Day') | Saturday |
| ,TO_CHAR(CURRENT_DATE, 'day') | saturday |
| ,TO_CHAR(CURRENT_DATE, 'DY') | SAT |
| ,TO_CHAR(CURRENT_DATE, 'Dy') | Sat |
| ,TO_CHAR(CURRENT_DATE, 'dy') | sat |
| ,TO_CHAR(CURRENT_DATE, 'AM') | AM |
| ,TO_CHAR(CURRENT_DATE, 'PM') | AM |
| ,TO_CHAR(CURRENT_DATE, 'WW') | 03 |
| ,TO_CHAR(CURRENT_DATE, 'IYYY') | 2024 |
| ,TO_CHAR(CURRENT_DATE, 'IW') | 03 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY/MM/DD') | 2024/01/20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD') | 2024-01-20 |
| ,TO_CHAR(CURRENT_DATE, 'YY/MM/DD') | 24/01/20 |
| ,TO_CHAR(CURRENT_DATE, 'YY-MM-DD') | 24-01-20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY MONTH DD') | 2024 JANUARY 20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY FMMonth DD') | 2024 January 20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY Month DD') | 2024 January 20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY month DD') | 2024 january 20 |
| ,TO_CHAR(CURRENT_DATE, 'YEAR') | TWENTY TWENTY-FOUR |
| ,TO_CHAR(CURRENT_DATE, 'Year') | Twenty Twenty-Four |
| ,TO_CHAR(CURRENT_DATE, 'year') | twenty twenty-four |
| ,TO_CHAR(CURRENT_DATE, 'YYYYDDD') | 2024020 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY.DDD') | 2024.020 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY:MM:DD') | 2024:01:20 |
| ,TO_CHAR(CURRENT_DATE, 'YYMMDD') | 240120 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-MON-DD') | 2024-JAN-20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-Mon-DD') | 2024-Jan-20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-mon-DD') | 2024-jan-20 |
| ,TO_CHAR(CURRENT_DATE, 'YY/MON/DD') | 24/JAN/20 |
| ,TO_CHAR(CURRENT_DATE, 'YY/Mon/DD') | 24/Jan/20 |
| ,TO_CHAR(CURRENT_DATE, 'YY/mon/DD') | 24/jan/20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY DDD') | 2024 020 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-MM') | 2024-01 |
| ,TO_CHAR(CURRENT_DATE, 'YY-MON-DD') | 24-JAN-20 |
| ,TO_CHAR(CURRENT_DATE, 'YY-Mon-DD') | 24-Jan-20 |
| ,TO_CHAR(CURRENT_DATE, 'YY-mon-DD') | 24-jan-20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY Q') | 2024 1 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY:MON:DD') | 2024:JAN:20 |
| ,TO_CHAR(CURRENT_DATE, 'YYYYDDDHHMISS') | 2024020120000 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY DDDth DAY') | 2024 020TH SATURDAY |
| ,TO_CHAR(CURRENT_DATE, 'YYYY DDDth Day') | 2024 020TH Saturday |
| ,TO_CHAR(CURRENT_DATE, 'YYYY DDDth day') | 2024 020TH saturday |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD"T"HH24:MI:SS') | 2024-01-20T00:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY-MM-DD HH:MI:SS.FF3') | 2024-01-20 12:00:00.000 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY Q "Quarter" Q') | 2024 1 Quarter 1 |
| ,TO_CHAR(CURRENT_DATE, 'YYYY Q "Quarter"') | 2024 1 Quarter |
| ,TO_CHAR(CURRENT_DATE, 'MM/DD/YYYY') | 01/20/2024 |
| ,TO_CHAR(CURRENT_DATE, 'MM-DD-YYYY') | 01-20-2024 |
| ,TO_CHAR(CURRENT_DATE, 'MONTH DD, YYYY') | JANUARY 20, 2024 |
| ,TO_CHAR(CURRENT_DATE, 'Month DD, YYYY') | January 20, 2024 |
| ,TO_CHAR(CURRENT_DATE, 'month DD, YYYY') | january 20, 2024 |
| ,TO_CHAR(CURRENT_DATE, 'MM-DD-YY') | 01-20-24 |
| ,TO_CHAR(CURRENT_DATE, 'MON-DD-YYYY') | JAN-20-2024 |
| ,TO_CHAR(CURRENT_DATE, 'Mon-DD-YYYY') | Jan-20-2024 |
| ,TO_CHAR(CURRENT_DATE, 'mon-DD-YYYY') | jan-20-2024 |
| ,TO_CHAR(CURRENT_DATE, 'MONTH-DD-YYYY') | JANUARY -20-2024 |
| ,TO_CHAR(CURRENT_DATE, 'MM-DDD-YYYY') | 01-020-2024 |
| ,TO_CHAR(CURRENT_DATE, 'MONTH-MM-DDD-YYYY') | JANUARY -01-020-2024 |
| ,TO_CHAR(CURRENT_DATE, 'MONTH') | JANUARY |
| ,TO_CHAR(CURRENT_DATE, 'Month') | January |
| ,TO_CHAR(CURRENT_DATE, 'month') | january |
| ,TO_CHAR(CURRENT_DATE, 'MON') | JAN |
| ,TO_CHAR(CURRENT_DATE, 'Mon') | Jan |
| ,TO_CHAR(CURRENT_DATE, 'mon') | jan |
| ,TO_CHAR(CURRENT_DATE, 'MM-YY') | 01-24 |
| ,TO_CHAR(CURRENT_DATE, 'MM/DD/YY') | 01/20/24 |
| ,TO_CHAR(CURRENT_DATE, 'MM:DD:YY') | 01:20:24 |
| ,TO_CHAR(CURRENT_DATE, 'MON-DD-YY') | JAN-20-24 |
| ,TO_CHAR(CURRENT_DATE, 'MM,DD,YYYY') | 01,20,2024 |
| ,TO_CHAR(CURRENT_DATE, 'Mon, DD YYYY') | Jan, 20 2024 |
| ,TO_CHAR(CURRENT_DATE, 'MM/DD/YYYY HH:MI AM') | 01/20/2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'MM/DD/YY HH24:MI:SS') | 01/20/24 00:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'Mon DD, YYYY HH:MI:SS') | Jan 20, 2024 12:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'MM-DD-YYYY HH12:MI:SS AM') | 01-20-2024 12:00:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'FMMonth DD, YYYY HH:MI:SS') | January 20, 2024 12:0:0 |
| ,TO_CHAR(CURRENT_DATE, 'DD-MON-YYYY') | 20-JAN-2024 |
| ,TO_CHAR(CURRENT_DATE, 'DD-MON-YY') | 20-JAN-24 |
| ,TO_CHAR(CURRENT_DATE, 'DD/MM/YYYY') | 20/01/2024 |
| ,TO_CHAR(CURRENT_DATE, 'DD-MM-YYYY') | 20-01-2024 |
| ,TO_CHAR(CURRENT_DATE, 'DD MON YYYY') | 20 JAN 2024 |
| ,TO_CHAR(CURRENT_DATE, 'DAY,DD MONTH YYYY') | SATURDAY ,20 JANUARY 2024 |
| ,TO_CHAR(CURRENT_DATE, 'DAY-MM-DDD-YYYY') | SATURDAY -01-020-2024 |
| ,TO_CHAR(CURRENT_DATE, 'day-MM-DDD-YYYY') | saturday -01-020-2024 |
| ,TO_CHAR(CURRENT_DATE, 'DAY') | SATURDAY |
| ,TO_CHAR(CURRENT_DATE, 'Day') | Saturday |
| ,TO_CHAR(CURRENT_DATE, 'day') | saturday |
| ,TO_CHAR(CURRENT_DATE, 'Q') | 1 |
| ,TO_CHAR(CURRENT_DATE, 'DD/MON/YYYY') | 20/JAN/2024 |
| ,TO_CHAR(CURRENT_DATE, 'DD/MM/YY') | 20/01/24 |
| ,TO_CHAR(CURRENT_DATE, 'Dy') | Sat |
| ,TO_CHAR(CURRENT_DATE, 'Dy, DD Mon YYYY') | Sat, 20 Jan 2024 |
| ,TO_CHAR(CURRENT_DATE, 'DDD') | 020 |
| ,TO_CHAR(CURRENT_DATE, 'DDD, YYYY') | 020, 2024 |
| ,TO_CHAR(CURRENT_DATE, 'Dy, DD Mon YYYY HH:MI:SS') | Sat, 20 Jan 2024 12:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'DD/MM/YY HH:MI AM') | 20/01/24 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'DY DD MONTH YYYY HH24:MI:SS') | SAT 20 JANUARY 2024 00:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'DD-MON-YYYY HH:MI AM') | 20-JAN-2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'D "Day of Week"') | 7 Day of Week |
| ,TO_CHAR(CURRENT_DATE, 'DY, DD MONTH YYYY HH12:MI:SS AM') | SAT, 20 JANUARY 2024 12:00:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'DDD HH:MI AM') | 020 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'DY, DD MONTH YYYY HH24:MI:SS.FF6') | SAT, 20 JANUARY 2024 00:00:00.000000 |
| ,TO_CHAR(CURRENT_DATE, 'HH:MI:SS') | 12:00:00 |
| ,TO_CHAR(CURRENT_DATE, 'HH:MI AM DY, DD Mon YYYY') | 12:00 AM SAT, 20 Jan 2024 |
| ,TO_CHAR(CURRENT_DATE, 'WW') | 03 |
| ,TO_CHAR(CURRENT_DATE, 'IYYY-IW') | 2024-03 |
| ,TO_CHAR(CURRENT_DATE, 'IW') | 03 |
| ,TO_CHAR(CURRENT_DATE, 'HH:MI:SS.FF6') | 12:00:00.000000 |
| ,TO_CHAR(CURRENT_DATE, 'HH:MI:SS AM DY, DD Mon YYYY') | 12:00:00 AM SAT, 20 Jan 2024 |
| ,TO_CHAR(CURRENT_DATE, 'HH12:MI:SS AM DY, DD Mon YYYY') | 12:00:00 AM SAT, 20 Jan 2024 |
| ,TO_CHAR(CURRENT_DATE, 'IW "Week"') | 03 Week |
| ,TO_CHAR(CURRENT_DATE, 'FMHH:MI:SS') | 12:0:0 |
| ,TO_CHAR(CURRENT_DATE, 'DY, DD MONTH YYYY HH12:MI AM') | SAT, 20 JANUARY 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'Dy, DD MONTH YYYY HH12:MI AM') | Sat, 20 JANUARY 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'dy, DD MONTH YYYY HH12:MI AM') | sat, 20 JANUARY 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'DY, DD Month YYYY HH12:MI AM') | SAT, 20 January 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'Dy, DD Month YYYY HH12:MI AM') | Sat, 20 January 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'dy, DD Month YYYY HH12:MI AM') | sat, 20 January 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'DY, DD month YYYY HH12:MI AM') | SAT, 20 january 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'Dy, DD month YYYY HH12:MI AM') | Sat, 20 january 2024 12:00 AM |
| ,TO_CHAR(CURRENT_DATE, 'dy, DD month YYYY HH12:MI AM') | sat, 20 january 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY/MM/DD') | 2024/12/31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-MM-DD') | 2024-12-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY/MM/DD') | 24/12/31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY-MM-DD') | 24-12-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY MONTH DD') | 2024 DECEMBER 31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY FMMonth DD') | 2024 December 31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY Month DD') | 2024 December 31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY month DD') | 2024 december 31 |
| ,TO_CHAR(DATE '2024-12-31', 'YEAR') | TWENTY TWENTY-FOUR |
| ,TO_CHAR(DATE '2024-12-31', 'Year') | Twenty Twenty-Four |
| ,TO_CHAR(DATE '2024-12-31', 'year') | twenty twenty-four |
| ,TO_CHAR(DATE '2024-12-31', 'YYYYDDD') | 2024366 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY.DDD') | 2024.366 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY:MM:DD') | 2024:12:31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYMMDD') | 241231 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-MON-DD') | 2024-DEC-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-Mon-DD') | 2024-Dec-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-mon-DD') | 2024-dec-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY/MON/DD') | 24/DEC/31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY/Mon/DD') | 24/Dec/31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY/mon/DD') | 24/dec/31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY DDD') | 2024 366 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-MM') | 2024-12 |
| ,TO_CHAR(DATE '2024-12-31', 'YY-MON-DD') | 24-DEC-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY-Mon-DD') | 24-Dec-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YY-mon-DD') | 24-dec-31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY Q') | 2024 4 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY:MON:DD') | 2024:DEC:31 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYYDDDHHMISS') | 2024366120000 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY DDDth DAY') | 2024 366TH TUESDAY |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY DDDth Day') | 2024 366TH Tuesday |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY DDDth day') | 2024 366TH tuesday |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-MM-DD"T"HH24:MI:SS') | 2024-12-31T00:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY-MM-DD HH:MI:SS.FF3') | 2024-12-31 12:00:00.000 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY Q "Quarter" Q') | 2024 4 Quarter 4 |
| ,TO_CHAR(DATE '2024-12-31', 'YYYY Q "Quarter"') | 2024 4 Quarter |
| ,TO_CHAR(DATE '2024-12-31', 'MM/DD/YYYY') A | 12/31/2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MM-DD-YYYY') | 12-31-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MONTH DD, YYYY') | DECEMBER 31, 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'Month DD, YYYY') | December 31, 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'month DD, YYYY') | december 31, 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MM-DD-YY') | 12-31-24 |
| ,TO_CHAR(DATE '2024-12-31', 'MON-DD-YYYY') | DEC-31-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'Mon-DD-YYYY') | Dec-31-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'mon-DD-YYYY') | dec-31-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MONTH-DD-YYYY') | DECEMBER -31-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MM-DDD-YYYY') | 12-366-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MONTH-MM-DDD-YYYY') | DECEMBER -12-366-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MONTH') | DECEMBER |
| ,TO_CHAR(DATE '2024-12-31', 'Month') | December |
| ,TO_CHAR(DATE '2024-12-31', 'month') | december |
| ,TO_CHAR(DATE '2024-12-31', 'MON') | DEC |
| ,TO_CHAR(DATE '2024-12-31', 'Mon') | Dec |
| ,TO_CHAR(DATE '2024-12-31', 'mon') | dec |
| ,TO_CHAR(DATE '2024-12-31', 'MM-YY') | 12-24 |
| ,TO_CHAR(DATE '2024-12-31', 'MM/DD/YY') | 12/31/24 |
| ,TO_CHAR(DATE '2024-12-31', 'MM:DD:YY') | 12:31:24 |
| ,TO_CHAR(DATE '2024-12-31', 'MON-DD-YY') | DEC-31-24 |
| ,TO_CHAR(DATE '2024-12-31', 'MM,DD,YYYY') | 12,31,2024 |
| ,TO_CHAR(DATE '2024-12-31', 'Mon, DD YYYY') | Dec, 31 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'MM/DD/YYYY HH:MI AM') | 12/31/2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'MM/DD/YY HH24:MI:SS') | 12/31/24 00:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'Mon DD, YYYY HH:MI:SS') | Dec 31, 2024 12:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'MM-DD-YYYY HH12:MI:SS AM') | 12-31-2024 12:00:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'FMMonth DD, YYYY HH:MI:SS') | December 31, 2024 12:0:0 |
| ,TO_CHAR(DATE '2024-12-31', 'DD-MON-YYYY') | 31-DEC-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DD-MON-YY') | 31-DEC-24 |
| ,TO_CHAR(DATE '2024-12-31', 'DD/MM/YYYY') | 31/12/2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DD-MM-YYYY') | 31-12-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DD MON YYYY') | 31 DEC 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DAY,DD MONTH YYYY') | TUESDAY ,31 DECEMBER 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DAY-MM-DDD-YYYY') | TUESDAY -12-366-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'day-MM-DDD-YYYY') | tuesday -12-366-2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DAY') | TUESDAY |
| ,TO_CHAR(DATE '2024-12-31', 'Day') | Tuesday |
| ,TO_CHAR(DATE '2024-12-31', 'day') | tuesday |
| ,TO_CHAR(DATE '2024-12-31', 'Q') | 4 |
| ,TO_CHAR(DATE '2024-12-31', 'DD/MON/YYYY') | 31/DEC/2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DD/MM/YY') | 31/12/24 |
| ,TO_CHAR(DATE '2024-12-31', 'Dy') | Tue |
| ,TO_CHAR(DATE '2024-12-31', 'Dy, DD Mon YYYY') L | Tue, 31 Dec 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'DDD') | 366 |
| ,TO_CHAR(DATE '2024-12-31', 'DDD, YYYY') | 366, 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'Dy, DD Mon YYYY HH:MI:SS') | Tue, 31 Dec 2024 12:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'DD/MM/YY HH:MI AM') | 31/12/24 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'DY DD MONTH YYYY HH24:MI:SS') | TUE 31 DECEMBER 2024 00:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'DD-MON-YYYY HH:MI AM') | 31-DEC-2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'D "Day of Week"') | 3 Day of Week |
| ,TO_CHAR(DATE '2024-12-31', 'DY, DD MONTH YYYY HH12:MI:SS AM') | TUE, 31 DECEMBER 2024 12:00:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'DDD HH:MI AM') | 366 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'DY, DD MONTH YYYY HH24:MI:SS.FF6') | TUE, 31 DECEMBER 2024 00:00:00.000000 |
| ,TO_CHAR(DATE '2024-12-31', 'HH:MI:SS') | 12:00:00 |
| ,TO_CHAR(DATE '2024-12-31', 'HH:MI AM DY, DD Mon YYYY') | 12:00 AM TUE, 31 Dec 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'WW') | 53 |
| ,TO_CHAR(DATE '2024-12-31', 'IYYY-IW') | 2025-01 |
| ,TO_CHAR(DATE '2024-12-31', 'IW') | 01 |
| ,TO_CHAR(DATE '2024-12-31', 'HH:MI:SS.FF6') | 12:00:00.000000 |
| ,TO_CHAR(DATE '2024-12-31', 'HH:MI:SS AM DY, DD Mon YYYY') | 12:00:00 AM TUE, 31 Dec 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'HH12:MI:SS AM DY, DD Mon YYYY') | 12:00:00 AM TUE, 31 Dec 2024 |
| ,TO_CHAR(DATE '2024-12-31', 'IW "Week"') | 01 Week |
| ,TO_CHAR(DATE '2024-12-31', 'FMHH:MI:SS') | 12:0:0 |
| ,TO_CHAR(DATE '2024-12-31', 'DY, DD MONTH YYYY HH12:MI AM') | TUE, 31 DECEMBER 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'Dy, DD MONTH YYYY HH12:MI AM') | Tue, 31 DECEMBER 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'dy, DD MONTH YYYY HH12:MI AM') | tue, 31 DECEMBER 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'DY, DD Month YYYY HH12:MI AM') | TUE, 31 December 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'Dy, DD Month YYYY HH12:MI AM') | Tue, 31 December 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'dy, DD Month YYYY HH12:MI AM') | tue, 31 December 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'DY, DD month YYYY HH12:MI AM') | TUE, 31 december 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'Dy, DD month YYYY HH12:MI AM') | Tue, 31 december 2024 12:00 AM |
| ,TO_CHAR(DATE '2024-12-31', 'dy, DD month YYYY HH12:MI AM') | tue, 31 december 2024 12:00 AM |