# \#date-and-time

**URL:** https://discourse.getdbt.com/tag/date-and-time/10.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [New Package: dbt-date](https://discourse.getdbt.com/t/new-package-dbt-date/624)

<div class="topic-metadata">

**Author:** [@claus](https://discourse.getdbt.com/u/claus)\
**Replies:** 3\
**Last updated:** [January 30, 2026, 12:17am UTC](https://discourse.getdbt.com/t/new-package-dbt-date/624 "2026-01-30T00:17:11Z")

</div>

I’ve been collecting simple date helper functions in a package for clients, and have now broken them out into their own package, dbt-date, which you can find here: The current release is 0.1.3. The README has, hopefull…

---

## [Date Dimensions](https://discourse.getdbt.com/t/date-dimensions/735)

<div class="topic-metadata">

**Author:** [@josh](https://discourse.getdbt.com/u/josh)\
**Replies:** 6\
**Last updated:** [September 24, 2025, 8:29pm UTC](https://discourse.getdbt.com/t/date-dimensions/735 "2025-09-24T20:29:18Z")

</div>

Hello All – We have built a date dimension. Just wanted to share our code and results here and see if others have built their date dimensions differently, anything that you would add/remove, etc.? {{ config( pre\_hoo…

---

## [Using variables inside the dbt\_utils.date\_spine macro](https://discourse.getdbt.com/t/using-variables-inside-the-dbt-utils-date-spine-macro/6566)

<div class="topic-metadata">

**Author:** [@dschupak](https://discourse.getdbt.com/u/dschupak)\
**Replies:** 10\
**Last updated:** [January 23, 2025, 8:26pm UTC](https://discourse.getdbt.com/t/using-variables-inside-the-dbt-utils-date-spine-macro/6566 "2025-01-23T20:26:17Z")

</div>

I’m trying to create a date spine that where the first and last timestamps are taken from another model. For example, if I have a table that shows the times that someone logs onto their computer, I want to create a date…

---

## [Time zones in the Semantic Layer](https://discourse.getdbt.com/t/time-zones-in-the-semantic-layer/10622)

<div class="topic-metadata">

**Author:** [@jeff.huth](https://discourse.getdbt.com/u/jeff.huth)\
**Replies:** 1\
**Last updated:** [November 4, 2023, 12:29am UTC](https://discourse.getdbt.com/t/time-zones-in-the-semantic-layer/10622 "2023-11-04T00:29:52Z")

</div>

This article is from 2018. What is dbt’s perspective on time zones (and roll-up aggregates to dates or months) with the dbt semantic/metrics layer?

---

## [FAQ: Handling timezone conversion (and timestamp truncation) in data warehouses](https://discourse.getdbt.com/t/faq-handling-timezone-conversion-and-timestamp-truncation-in-data-warehouses/133)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 0\
**Last updated:** [September 27, 2018, 9:09pm UTC](https://discourse.getdbt.com/t/faq-handling-timezone-conversion-and-timestamp-truncation-in-data-warehouses/133 "2018-09-27T21:09:35Z")

</div>

A common question we see in the dbt community is around how people are handling timestamps in their data warehouse – more specifically: whether people store timestamps in UTC or in a timezone, or both, and whether peop…

---

## [Modeling changes to daily/weekly/monthly active users](https://discourse.getdbt.com/t/modeling-changes-to-daily-weekly-monthly-active-users/1631)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 2\
**Last updated:** [November 5, 2022, 8:19pm UTC](https://discourse.getdbt.com/t/modeling-changes-to-daily-weekly-monthly-active-users/1631 "2022-11-05T20:19:10Z")

</div>

Jump straight to the project docs, or to the source code This article was prompted by a question from a team member :slight\_smile: Our data Let’s say we have a table with one record per user, per day they were active…

---

## [Finding active days for a subscription/user/account (date spining)](https://discourse.getdbt.com/t/finding-active-days-for-a-subscription-user-account-date-spining/265)

<div class="topic-metadata">

**Author:** [@claire](https://discourse.getdbt.com/u/claire)\
**Replies:** 5\
**Last updated:** [August 3, 2021, 3:41am UTC](https://discourse.getdbt.com/t/finding-active-days-for-a-subscription-user-account-date-spining/265 "2021-08-03T03:41:43Z")

</div>

Every often, someone asks us about finding the active days for a subscription/user/account. We call this pattern “date spining” For example, this question was asked on dbt Slack last week: Any idea how to calculate th…

---

## [Building a Calendar Table using dbt](https://discourse.getdbt.com/t/building-a-calendar-table-using-dbt/325)

<div class="topic-metadata">

**Author:** [@emilie](https://discourse.getdbt.com/u/emilie)\
**Replies:** 0\
**Last updated:** [April 29, 2019, 10:12pm UTC](https://discourse.getdbt.com/t/building-a-calendar-table-using-dbt/325 "2019-04-29T22:12:02Z")

</div>

At GitLab, our data team loves dbt, not just for the power of the tool, but also for the power of the community. All too often, I find myself coming up with a hacky macro only to find that there’s already a solution for …
