An error occured when I run the code of 'arterial_line_durations.sql'

[zhaoFeH]

Prerequisites

• Put an X between the brackets on this line if you have done all of the following:
  • Checked the online documentation: https://mimic.physionet.org/about/mimic/
  • Checked that your issue isn't already addressed: https://github.com/MIT-LCP/mimic-code/issues?utf8=%E2%9C%93&q=

Description

Description of the issue, including:

**Hello, I found an error when I run the code of 'arterial_line_durations.sql' on the BigQuery. The error log is 'No matching signature for operator - for argument types: DATETIME, DATETIME. Supported signatures: INT64 - INT64; NUMERIC - NUMERIC; BIGNUMERIC - BIGNUMERIC; FLOAT64 - FLOAT64; DATE - INT64 at [134:7]'

The error happened at the line 134, the variable 'charttime' is red underlined. I don't know how to solve this error. Please help !**

The error pictures are as following:

[alistairewj]

This is a bug in the script - it hasn't been updated from PostgreSQL syntax to BigQuery syntax. You can fix it locally (and put in a PR if you have time) by replacing date subtractions with DATETIME_DIFF(date1, date2, date_part). Other scripts have examples of the syntax.

[zhaoFeH]

thank you very much!