Confirmed users
293
edits
Telemetry/LongitudinalExamples: Difference between revisions
Telemetry/LongitudinalExamples (view source)
Revision as of 15:53, 7 September 2016
, 7 September 2016Fix typo in longitudinal recent submission date query
(Organize table structure section) |
m (Fix typo in longitudinal recent submission date query) |
||
| Line 75: | Line 75: | ||
* Parsing most recent submission_date | * Parsing most recent submission_date | ||
SELECT DATE_PARSE(submission_date[1], '%Y-%m-%dT00:00:00.000Z') as | SELECT DATE_PARSE(submission_date[1], '%Y-%m-%dT00:00:00.000Z') as parsed_submission_date | ||
FROM longitudinal | FROM longitudinal | ||