Formatting dates for reports
Using dates and timestamps effectively in BigQuery is a core skill, especially when working with long datasets with multiple entries. This exercise will walk through several ways to query a timestamp from our orders dataset.
Diese Übung ist Teil des Kurses
Introduction to BigQuery
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
-- Finish the query to find sales on
SELECT
COUNT(order_id)
FROM
ecommerce.ecomm_order_details
-- Add the correct date part and date using the correct format
WHERE EXTRACT(___ from order_purchase_timestamp) = '___'