Table Columns in Database

When I try to pull a query of information out of the table the date and the datevalue is all blank and tstamp values are in long integers. How does anyone suggest querying information and why are those columns like that?

Using long integers as t_stamp helps with DB flavor independence and maybe a modest performance optimization on some. Those are milliseconds since Jan 1, 1970.

Is it safe to assume you’re using the Tag Historian module to collect the records? If so, then try using a Tag History Binding on the table instead, as it will automatically convert the time for you.

1 Like