fix bad year comparison

RMI-PACTA / workflow.factset

Other

0 stars 0 forks source link

fix bad year comparison #5

Closed AlexAxthelm closed 7 months ago

AlexAxthelm commented 7 months ago

using lubridate::year(data_timestamp) caused an error when running the SQL query, because PostgreSQL doesn't know how extract a year from an arbitrary string. Explicitly converting outside of SQL allows the comparison to proceed as expected.

github-actions[bot] commented 7 months ago

Docker image from this PR (86f6f6f6a4951058e386f02ad9f31489964781cc) created

docker pull ghcr.io/rmi-pacta/workflow.factset:pr5