1. Learn
  2. /
  3. Courses
  4. /
  5. Introduction to BigQuery

Connected

Exercise

Formatting timestamps and dates

Timestamps can be confusing when viewed as text (e.g., '2020-06-02 23:57:12.120174 UTC'), especially in a report format. Ensuring that your reports are easy to understand can be a factor in determining how your results are used.

Instructions

100 XP
  • Add the date formatting for the column order_purchase_timestamp in the 'MM/DD/YY' format using the %D option.