# Reporting time stamp

**URL:** <https://forum.inductiveautomation.com/t/reporting-time-stamp/42341>\
**Category:** Ignition\
**Created:** [January 18, 2021, 12:07am UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341 "2021-01-18T00:07:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![santoshb189](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@santoshb189](https://forum.inductiveautomation.com/u/santoshb189)\
**Post date:** [January 18, 2021, 12:07am UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341/1 "2021-01-18T00:07:29Z")

</div>

Hi, currently I am generating a report with past 12 hours data. My query is  
SELECT \* FROM group\_table WHERE group\_table.t\_stamp \< ? AND group\_table.t\_stamp \> ?  
1st ? - EndDate-now()  
2nd ? - StartDate- dateArithmetic(now(), -12, “hr”)  
In my database MySQL, I see that data is being recorded with time stamp - time stamp is in date and time format

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/963ed5cc6a1f7a157b7b0836739063c3d2109d2b.png)  
where as in Ignition in Reports-\>preview mode only date is visible, time is not being displayed  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/2/02f14c2bf50af48531e3ca70e9c814eb1e7047bd.png)  
Do I need to change any of settings or should the query be modified? Thanks in advance.

---

<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:** [January 18, 2021, 12:46pm UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341/2 "2021-01-18T12:46:17Z")

</div>

Look at the date format for that column in the report table. You should be able to include time formatting codes.

---

<div class="post-metadata">

**Author:** ![santoshb189](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@santoshb189](https://forum.inductiveautomation.com/u/santoshb189)\
**Post date:** [January 18, 2021, 5:07pm UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341/3 "2021-01-18T17:07:54Z")

</div>

but in reporting, I have dragged and dropped the time stamp. Can we also include formatting for this?

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [January 18, 2021, 5:27pm UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341/4 "2021-01-18T17:27:10Z")

</div>

7.9 or 8.0+?

In 7.9, drag it over, then in Property Inspector click Properties and scroll down to Date Format

---

<div class="post-metadata">

**Author:** ![santoshb189](https://avatars.discourse-cdn.com/v4/letter/s/74df32/32.png) [@santoshb189](https://forum.inductiveautomation.com/u/santoshb189)\
**Post date:** [January 19, 2021, 12:09am UTC](https://forum.inductiveautomation.com/t/reporting-time-stamp/42341/5 "2021-01-19T00:09:45Z")

</div>

Thanks, this is the setting I was looking for.