# How to troubleshoot \`TIMESTAMP\_TZ\` datetime confusion in Snowflake

**URL:** <https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80>\
**Category:** Modeling\
**Created:** [May 30, 2024, 7:59pm UTC](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80 "2024-05-30T19:59:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![conner](https://yyz2.discourse-cdn.com/flex004/user_avatar/community.omni.co/conner/32/11_2.png) [@conner](https://community.omni.co/u/conner)\
**Post date:** [May 30, 2024, 7:59pm UTC](https://community.omni.co/t/how-to-troubleshoot-timestamp-tz-datetime-confusion-in-snowflake/80/1 "2024-05-30T19:59:33Z")

</div>

Snowflake has a data type called `TIMESTAMP_TZ`, which stores timestamps in UTC alongside a timezone offset. When querying this datatype in Omni, this data type lead to confusion and seemingly inconsistent behavior when querying and filtering data on the margins of dates.

**We recommend converting out of this data type in Omni by casting to the `TIMESTAMP_LTZ` data type.** This will store the timestamp field in UTC, and then Omni’s [timezone settings](https://docs.omni.co/docs/connections/timezone_settings/) will be applied to give you more control. Read more about `TIMESTAMP_LTZ` in [Snowflake’s documentation](https://docs.snowflake.com/en/sql-reference/data-types-datetime).