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
where as in Ignition in Reports->preview mode only date is visible, time is not being displayed
Do I need to change any of settings or should the query be modified? Thanks in advance.