# 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:** 5

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 7, 2024, 3:58pm UTC](https://forum.inductiveautomation.com/t/sql-select-getting-wrong-time/94299/5 "2024-08-07T15:58:07Z")

</div>

> [@Alex\_Leech](#):
>
> Running:
> 
> ```python
> SELECT GETUTCDATE()
> 
> ```
> 
> Returns the UTC date - 1 hour

Well, it has to the render the datetime+zone in the user's timezone when printing that result.

Use the techniques in this topic to render in a particular time zone:

> [@Ignition Perspective Page to show the client System date and time](https://forum.inductiveautomation.com/t/ignition-perspective-page-to-show-the-client-system-date-and-time/73265/8):
>
> Sure. I recommend [DateTimeFormatter.ofPattern()](https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/time/format/DateTimeFormatter.html#ofPattern(java.lang.String)). But I would move the complexity to a project script module with a DateTimeFormatter instance with your preferred pattern saved as a top level variable. Like so, perhaps: from java.time import ZoneId from java.time.format import DateTimeFormatter defaultFormatter = DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm") def zonedFormat(ts, zoneid, format=None): formatter = defaultFormatter if format is None else DateTimeFormatter.ofPattern(format) r…

---

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