DataExpert-io/data-engineer-handbook

DATE_TRUNC function in user_cumulated_populate.sql

Closed this issue · 1 comments

bootcamp/materials/2-fact-data-modeling/lecture-lab/user_cumulated_populate.sql
conflicts with
bootcamp/materials/1-dimensional-data-modeling/docker-compose.yml
that specifies
image: postgres:14

reason: DATE_TRUNC function is not available in 14. Current pg version is 17.
looks like DATE function delivers the same results as far as script concerned.

DATE_TRUNC function is available in 14.