I maybe missing somethin simple to explain what is going on. I am trying to get another problem solved and I encountered the following issue that is very different from other DB’s I use.
I have the following query:
1. Update un_hi_device_loc Set un_hi_rec_id = my_ts_unix
This results in the un_hi_rec_id field to be set correctly with the my_ts_unix value from the associated row
2. Update un_hi_device_loc Set un_hi_rec_id = my_ts_unix / 10
This results in a 0 set in the column un_hi_rec_id for all rows the table
What is happening whenever I add, subtract, divide, or multiply the my_ts_unix field value? It does not do the expected mathematical calculation. The my_ts_unix is a LONG type. The same results happen if I run the same tests with a SELECT statement