Building a dataset with <type 'java.sql.Timestamp'> and <type 'java.util.Date'>

Ignition
,
1

I have 2 datasets, one that comes from a query and one that is stored in a tag.

For some reason, there datatype of the tag is <type 'java.sql.Timestamp'> and the one returned by the named query is <type 'java.util.Date'>.

When doing:

system.dataset.toDataSet(
	list(new_dataset.columnNames),
	filtered_data
)

Where filtered_data is list(existing_dataset) + list(new_dataset).
The problem is that the first list has the sql type and the other list has util.Date.

Traceback (most recent call last):
  File "<input>", line 1, in <module>
  File "<module:x>", line 471, in function
TypeError: Unable to convert row 11, column 0 to type class java.sql.Timestamp

What could I do?
Thx!

2

Use the DatasetBuilder to deliberately set column types, and use java.util.Date. java.sql.Timestamp is a subclass of Date, so can be placed in columns of that type. (But not the reverse.)