# Current time in report

**URL:** <https://forum.inductiveautomation.com/t/current-time-in-report/6176>\
**Category:** Ignition\
**Created:** [April 8, 2013, 8:02pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176 "2013-04-08T20:02:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [April 8, 2013, 8:02pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176/1 "2013-04-08T20:02:21Z")

</div>

Can I add the current time to a report somehow if it isn’t a value that is stored in my table?

---

<div class="post-metadata">

**Author:** ![Pat](https://avatars.discourse-cdn.com/v4/letter/p/8491ac/32.png) [@Pat](https://forum.inductiveautomation.com/u/Pat)\
**Post date:** [April 8, 2013, 8:39pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176/2 "2013-04-08T20:39:02Z")

</div>

MySQL`SELECT NOW()`  
MSSQL`SELECT GETDATE()`

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [April 10, 2013, 3:59pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176/3 "2013-04-10T15:59:09Z")

</div>

Postgres

```auto
SELECT NOW()
```

Just for completeness 🙂

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 10, 2013, 4:20pm UTC](https://forum.inductiveautomation.com/t/current-time-in-report/6176/4 "2013-04-10T16:20:36Z")

</div>

You can also just add a date custom property to the report that is bound to the following expression:`now(0)`