refactor: use `datediff`/`dateadd` macro

OHDSI / dbt-synthea

[Under development] A dbt ETL project to convert a Synthea synthetic data set into the OMOP CDM

https://ohdsi.github.io/dbt-synthea/

Apache License 2.0

16 stars 6 forks source link

Closed lawrenceadams closed 1 month ago

lawrenceadams commented 1 month ago

various sql engines do not allow interval extraction from delta (as deltas are passed as numeric types); concretely: snowflake, likely others
use the dbt standard datediff/dateadd macro to open up possibility to other sql engines
arguably more idiomatic
bring in line with other recent changes by @katy-sadowski