Written by Tom Coffing

I might be setting myself up for disappointment, but my goal for this blog is that it is the greatest blog of all humankind.

My hopes are high because date functions and formatting are the Achilles Heel for everyone working with SQL, especially when you move to a new system. After all, each database treats dates, times, and timestamps radically differently, and finding great examples with clear explanations isn’t easy.

So, I have spent months perfecting date functions and formatting for the top 15 most popular databases. I have everything you need from this point forward in your career to master all date functions and formatting, and I personally tested every single one of them myself.

I have the 45 links listed for you 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. I hope to meet you and say thanks in my next class at your company:)

https://coffingdw.com/education/

Here are three links to blogs for Snowflake date functions, date formats, and timestamp formats.

https://coffingdw.com/great-snowflake-date-functions-to-know/
https://coffingdw.com/snowflake-formatting-dates-with-the-to_char-function/
https://coffingdw.com/5000-snowflake-timestamp-format-examples/

Here are three links to blogs for Databricks date functions, date formats, and timestamp formats.

https://coffingdw.com/dive-into-dazzling-databricks-date-functions/
https://coffingdw.com/databricks-formatting-dates-with-the-date_format-function/
https://coffingdw.com/20000-databricks-timestamp-format-examples/

Here are three links to blogs for Teradata date functions, date formats, and timestamp formats.

https://coffingdw.com/great-teradata-date-functions-to-know/
https://coffingdw.com/formatting-teradata-dates/
https://coffingdw.com/17000-teradata-timestamp-format-examples/

Here are three links to blogs for Azure Synapse date functions, date formats, and timestamp formats.

https://coffingdw.com/great-date-functions-for-azure-synapse/
https://coffingdw.com/how-to-format-dates-in-azure-synapse-over-1800-examples-included/
https://coffingdw.com/20000-azure-synapse-timestamp-format-examples/

Here are three links to blogs for SQL Server date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-date-functions-on-sql-server/
https://coffingdw.com/how-to-format-dates-in-sql-server-over-1800-examples-included/
https://coffingdw.com/20000-sql-server-timestamp-format-examples/

Here are three links to blogs for Amazon Redshift date functions, date formats, and timestamp formats.

https://coffingdw.com/great-amazon-redshift-date-functions-to-know/
https://coffingdw.com/formatting-dates-on-amazon-redshift-3000-examples/
https://coffingdw.com/20000-amazon-redshift-timestamp-format-examples/

Here are three links to blogs for Google BigQuery date functions, date formats, and timestamp formats.

https://coffingdw.com/great-google-bigquery-date-functions-to-know/
https://coffingdw.com/formatting-dates-on-google-bigquery/
https://coffingdw.com/20000-google-bigquery-timestamp-format-examples/

Here are three links to blogs for Yellowbrick date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-dates-on-a-yellowbrick-data-warehouse/
https://coffingdw.com/formatting-dates-on-yellowbrick-2500-examples/
https://coffingdw.com/20000-yellowbrick-timestamp-format-examples/

Here are three links to blogs for Vertica date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-date-functions-on-vertica/
https://coffingdw.com/formatting-dates-on-vertica/
https://coffingdw.com/20000-vertica-timestamp-format-examples/

Here are three links to blogs for Postgres date functions, date formats, and timestamp formats.

https://coffingdw.com/great-postgres-date-functions-to-know/
https://coffingdw.com/formatting-a-postgres-date-3000-examples/
https://coffingdw.com/20000-postgres-timestamp-format-examples/

Here are three links to blogs for MySQL date functions, date formats, and timestamp formats.

https://coffingdw.com/great-mysql-date-functions-to-know/
https://coffingdw.com/formatting-dates-on-mysql/
https://coffingdw.com/9750-mysql-timestamp-format-examples/

Here are three links to blogs for Greenplum date functions, date formats, and timestamp formats.

https://coffingdw.com/great-greenplum-date-functions-to-know/
https://coffingdw.com/formatting-dates-on-greenplum-2500-examples/
https://coffingdw.com/20000-greenplum-timestamp-format-examples/

Here are three links to blogs for Oracle date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-oracle-date-functions/
https://coffingdw.com/formatting-dates-on-oracle/
https://coffingdw.com/17000-oracle-timestamp-format-examples/

Here are three links to blogs for IBM DB2 date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-ibm-db2-date-functions/
https://coffingdw.com/formatting-dates-on-ibm-db2/
https://coffingdw.com/20000-ibm-db2-timestamp-format-examples/

Here are three links to blogs for Netezza date functions, date formats, and timestamp formats.

https://coffingdw.com/mastering-netezza-date-functions/
https://coffingdw.com/formatting-dates-on-netezza/
https://coffingdw.com/20000-netezza-timestamp-format-examples/

And if your are ever looking for the greatest query tool ever built, one that can migrate entire databases instantly, one that can join 20 tables from 20 different systems in a single query, and one gives all who use it a huge advantage check out the video below.



Posted in Blog