1. सीखें
  2. /
  3. पाठ्यक्रम
  4. /
  5. Introduction to BigQuery

Connected

अभ्यास

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.

निर्देश

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