# Gateway Date & Time

**URL:** <https://forum.inductiveautomation.com/t/gateway-date-time/3546>\
**Category:** Ignition\
**Created:** [November 2, 2011, 9:26pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546 "2011-11-02T21:26:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jk\_Concept](https://avatars.discourse-cdn.com/v4/letter/j/d9b06d/32.png) [@jk\_Concept](https://forum.inductiveautomation.com/u/jk_Concept)\
**Post date:** [November 2, 2011, 9:26pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546/1 "2011-11-02T21:26:45Z")

</div>

In my project, I am using the now() function to pull the time from Ignition. I read in the manual that the value returned is actually the from the Clients clock. To prevent having to ensure that all client computers are synchronzed, I would like to be able to pull the time from the gateway and display it, and utilize it in some functions.

Is there any function to pull the Gateway time? Any work arounds if not?

Thanks

Jack

---

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [November 2, 2011, 10:21pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546/2 "2011-11-02T22:21:59Z")

</div>

SQL Query is one way of doing it.

[sqlzoo.net/fun\_current\_timestamp.htm](http://sqlzoo.net/fun_current_timestamp.htm)

---

<div class="post-metadata">

**Author:** ![rlparde](https://avatars.discourse-cdn.com/v4/letter/r/c37758/32.png) [@rlparde](https://forum.inductiveautomation.com/u/rlparde)\
**Post date:** [September 6, 2013, 2:25pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546/3 "2013-09-06T14:25:30Z")

</div>

I’m not sure if my issue is directly related or not.  
But we are using an SQL expression tag “now(10)”, to return the current time.  
The “value” in the SQLTags Browser is correct. However, the time displayed in the Data,Text that references the tag in the ignition window is 5 hours ahead.

If I open the"Tag Diagnostics"  
the “value” shows the correct time  
the “value Timestamp” shows the correct time  
the “Last Execution” indicates correct date but 5 hours ahead

This happen one time before since we up graded to the newer Ignition version 7.6.2.  
It seamed to self correct with a server reboot. This time we rebooted the server and the time did not self correct.

Any ideas? Or are there any known issues with the latest Ignition version?

Thanks

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [October 7, 2013, 1:21pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546/4 "2013-10-07T13:21:58Z")

</div>

These are not known issues with Ignition.

What version of Java are you using? I have seen in two previous cases, similar to yours, where an upgrade of Java fixed the issue. If you have not installed Ignition 7.6.3 already I would suggest upgrading to that and upgrading Java to 7 update 25.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 27, 2014, 1:44pm UTC](https://forum.inductiveautomation.com/t/gateway-date-time/3546/5 "2014-10-27T13:44:00Z")

</div>

Wanted to provide a quick update. There is now a system tag for this (7.7):

```auto
[System]Gateway/CurrentDateTime
```