Query tag history data

Ignition
1

Hi,

I would like to query tag history data in the database, using a where clause in the query that looks at the timestamp.

It looks like the timestamp is stored as data type bigint… i have a calendar on a vision screen that I want to use to use to get the date, but I can’t type cast it into a big int.

Is there another way I can convert a data type ‘date’ to something I can use in my where clause?

Thanks.

2

Variations of this will do. The bigint column in the history tables is unix timestamp milliseconds.from java.util import Date now = Date() bigint = now.getTime()