Wrong interpretation of a UNIX timestamp by DB Table Selector
I access a SQLite database using the SQLite Connector. The setup looks like this:
Everything works as expected except for a UNIX timestamp included in one of the tables.
When I fetch the first 100 values of the Table Selector Node, the values in the Timestamp column are entirely different from the original values.
Examples
Original value
Value in DB data selector
1700776930470
-30118746
1700776958389
-30090827
1700776984467
-30064749
1700776990824
| -30058392
::::::: ::::::
1700777094392
| -29954824
1700816719803
| 9670587
1700816740845
| 9691629
1700816757548
| 9708332
I have no idea why I have negative values in the DB data selector or why it changes to positive values at a certain point.
The data type is Number (integer).
Maybe the original Number has too many digits in the first place, but I do not receive any error messages.
Please advise!
regards
michael