CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Introduction to BigQuery

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- 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) = '___'
Modifier et exécuter le code