# Toad Data Point overwriting DB timezone?

**URL:** <https://forums.toadworld.com/t/toad-data-point-overwriting-db-timezone/58834>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [January 22, 2024, 8:30pm UTC](https://forums.toadworld.com/t/toad-data-point-overwriting-db-timezone/58834 "2024-01-22T20:30:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![erin.valdes](https://avatars.discourse-cdn.com/v4/letter/e/c5a1d2/32.png) [@erin.valdes](https://forums.toadworld.com/u/erin.valdes)\
**Post date:** [January 22, 2024, 8:30pm UTC](https://forums.toadworld.com/t/toad-data-point-overwriting-db-timezone/58834/1 "2024-01-22T20:30:34Z")

</div>

I have a connection to snowflake set up via toad data point. The timezone parameter in snowflake is set to America/New\_York on user/session/account level. However, TIMESTAMP\_LTZ fields are being defaulted in the toad data point to whatever timezone parameter toad is setting on its end. Where can I find the options to change this?

Example - these return different values.

```auto
select to_char(current_timestamp());
select current_timestamp();

```

to\_char gives us the correct timestamp based on snowflake America/New\_York timezone set on the user and session level. Not including to\_char returns the timestamp in my local timezone. I do not want everything converted to my local timezone.

Thanks!

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [January 22, 2024, 9:01pm UTC](https://forums.toadworld.com/t/toad-data-point-overwriting-db-timezone/58834/2 "2024-01-22T21:01:04Z")

</div>

Welcome to the TDP forum, Erin!

See snap below... You can change the way dates/times are displayed by going to the TDP options base, and reviewing the Date Type Formatting options on the Environment-\>Grid page, including your own custom masks. Hope this helps.

 ![image](https://global.discourse-cdn.com/quest/original/3X/4/2/42d16833f43375c2c37b52ce0ace54915fdbe0af.png)