20000 Databricks Timestamp Format Examples

You will love this blog because date, timestamp functions and formatting differ dramatically between databases, and Databricks handles them uniquely, but I have covered everything you need to know about formatting with brilliant examples and clear and concise explanations.

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/

Below are some great examples for formatting a Databricks timestamp to get you a great start to understanding how to use the date_format command.

yyyy: 4-digit year
yy: 2-digit year
MM: 2-digit month
M: 1 or 2-digit month
dd: 2-digit day of the month
d: 1 or 2-digit day of the month
hh: 2-digit hour in 12-hour format
HH: 2-digit hour in 24-hour format
mm: 2-digit minute
m: 1 or 2-digit minute
ss: 2-digit second
s: 1 or 2-digit second
a: AM/PM indicator
SSSSSS: Microsecond (6-digit precision)
SSS: Millisecond (3-digit precision)
MMMM: Full month name
MMM: Abbreviated month name
EEEE: Full day of the week
E: Abbreviated day of the week
D: Day of the year
G: Era (AD or BC)

The Databricks query example below uses the date_format function in the WHERE and AND clauses to only return rows where the day of the week is ‘Sat,’ the timestamp’s minutes = 54, and the month is December.

In the table below, you can see 20,000 different Databricks timestamp format examples.