I need to get the value of some historised tag.
As I know the moment (datetime), I’ve to get the name of the partition of history data inside the table sqlt_partitions. But the question is: how are the columns start_time and end_time represented? which format do they use? I saw those columns are bigint format, but if I need to filter in two datetimes, I have to convert to the correct format.
How can I know what dates includes in each partition?
For example: the table sqlt_partitions indicates that some partition of history tags is include between start_time and end_time. But, which are these dates?