Lakshay
Databricks Employee
Databricks Employee

Hi @Ivo Merchiers​ ,

Here is how I did it. As you mentioned, I am considering a date with milliseconds as input in "ts" column and offset to be added in "offSetMillis" column. First of all, I converted the "ts" column to milliseconds and then added "offSetMillis" to it and finally converted this new value back to timestamp in "new_ts" column

Screenshot 2023-02-06 at 6.50.51 PM

View solution in original post