data-engineer-handbook icon indicating copy to clipboard operation
data-engineer-handbook copied to clipboard

Published 20 hours ago • verified publisher icon DataExpert-io

DATE_TRUNC function in user_cumulated_populate.sql

Open pavlokurochka opened this issue 1 year ago • 0 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.

pavlokurochka avatar Nov 27 '24 18:11 pavlokurochka