system.tag.queryTagHistory() return sql.Timestamp, Why?

I’m confuse about this.

The column ‘t_stamp’ type, return by system.tag.queryTagHistory() , is class of java.sql.Timestamp but only sometimes, most of times it’s java.util.Date type. What is going on?

java.sql.Timestamp is a subclass of Date that offer precision to nanoseconds. JDBC drivers generally return Timestamp for DateTime columns if there are any fractional seconds, and must return Timestamp if the column value has better than millisecond precision.

You can treat them just like Date. If you are asking because of problems with the recent change to strict types in dataset tags, look at the latest nightly changelogs.

1 Like