When I look up on Google how to format a date on a specific database I see many short blogs with a few lame examples that don’t tell the whole story, so I decided to do something about it.

My comprehensive study put together a staggering 35,000 date format examples across the top 15 databases.

I created 15 blogs, one per database, that begin by showing you the basics of formatting a date for that database. I then give you all components so you can format the date yourself. I then show you a table of examples and the result of worldwide format standards and then how U.S. business format dates in different industries. And finally, I show a table of thousands of examples I put together and tested myself so you know they will work.

Here is a link to each specific blog.

Snowflake: https://coffingdw.com/snowflake-formatting-dates-with-the-to_char-function/

Databricks: https://coffingdw.com/databricks-formatting-dates-with-the-date_format-function/

Amazon Redshift: https://coffingdw.com/formatting-dates-on-amazon-redshift-3000-examples/

Google BigQuery: https://coffingdw.com/formatting-dates-on-google-bigquery/

Synapse: https://coffingdw.com/how-to-format-dates-in-azure-synapse-over-1800-examples-included/

Oracle: https://coffingdw.com/formatting-dates-on-oracle/

MySQL: https://coffingdw.com/formatting-dates-on-mysql/

Postgres: https://coffingdw.com/formatting-a-postgres-date-3000-examples/

Netezza: https://coffingdw.com/formatting-dates-on-netezza/

Vertica: https://coffingdw.com/formatting-dates-on-vertica/

Yellowbrick: https://coffingdw.com/formatting-dates-on-yellowbrick-2500-examples/

Greenplum: https://coffingdw.com/formatting-dates-on-greenplum-2500-examples/

IBM DB2: https://coffingdw.com/formatting-dates-on-ibm-db2/

Teradata: https://coffingdw.com/formatting-teradata-dates/

SQL Server: https://coffingdw.com/how-to-format-dates-in-sql-server-over-1800-examples-included/

If you need anything please give me a call or write me an email.

Thank you,

Tom

Tom Coffing
CEO, Coffing Data Warehousing (30 years)
Phone: 513 300-0341
Email: Tom.Coffing@CoffingDW.com
Website: http://www.CoffingDW.com
YouTube: https://www.youtube.com/coffingdw

Posted in Blog