Wednesday, 21 December 2022

Postgresql - Between two timestamp/date

SELECT * FROM schemaname.tablename

WHERE columnname between '2022-12-14 00:00:00' AND '2022-12-19 14:00:03' ORDER BY 1 DESC


NOTE: Includes both the dates 2022-12-14 & 2022-12-19

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...