# SQL SELECT Getting Wrong Time

**URL:** <https://forum.inductiveautomation.com/t/sql-select-getting-wrong-time/94299>\
**Category:** Ignition\
**Tags:** database, perspective, ignition81\
**Created:** [August 7, 2024, 3:12pm UTC](https://forum.inductiveautomation.com/t/sql-select-getting-wrong-time/94299 "2024-08-07T15:12:24Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Alex\_Leech](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alex_leech/32/39391_2.png) [@Alex\_Leech](https://forum.inductiveautomation.com/u/Alex_Leech)\
**Post date:** [August 7, 2024, 3:48pm UTC](https://forum.inductiveautomation.com/t/sql-select-getting-wrong-time/94299/4 "2024-08-07T15:48:20Z")

</div>

Just going to add to this a bit further - Running:

```python
SELECT GETUTCDATE()

```

Returns the UTC date - 1 hour

This post seems ver relevant. Hopefully not what I'm going to have to do for all queries!

> [@Ignition Timezone of the server](https://forum.inductiveautomation.com/t/ignition-timezone-of-the-server/80848):
>
> Hi guys! My main server at the Michigan, an it's time zone is Chicago. However, my plants are ate the different time zones. I'm already have a lots of widgets that uses function now() for Tag History requests. In expression now() always return server time zone time. I tried to change Project-\>Project Properties-\>Designer-\>Timezone Behavior as well as Project-\>Project Properties-\>General-\> Project Timezone. But this has zero influence on function now(). Does anyone has similar problem?

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-select-getting-wrong-time/94299)._