Pull request submitted: Incorrect SQL syntax for BigQuery: TO_DATE() --> DATE()

National-COVID-Cohort-Collaborative / Phenotype_Data_Acquisition

The repository for code and documentation produced by the N3C Phenotype and Data Acquisition workstream

60 stars 35 forks source link

Open mgkahn opened 2 years ago

mgkahn commented 2 years ago

Fix to Phenotype 4.0 extract SQL for BigQuery replaces invalid TO_DATE() with valid DATE(). Script tested @ Colorado on GBQ.