dbt-sqlite icon indicating copy to clipboard operation
dbt-sqlite copied to clipboard

Implement date trunc

Open AlpAribal opened this issue 2 years ago • 1 comments

My stab at closing #27.

Opted to always return a datetime without checking/evaluating date, which enables the users to also pass a column name to it.

For tests, I did not use/inherit from BaseDateTrunc because it casts the result as date, which fails for sqlite. But I made sure to include tests for different edge cases and truncating for each datepart.

AlpAribal avatar Jun 03 '23 14:06 AlpAribal

@codeforkjeff @edgarrmondragon I do not have the rights to add reviewers, could you help me with that?

AlpAribal avatar Jul 21 '23 17:07 AlpAribal