To_timestamp() and TimeZone?

select to_timestamp((cast (‘1647936225782’ as decimal))/1000) == 2022-03-22 08:03:45.782

but the real time is the under。

i think it’s about TimeZone setting, but i don’t know how to setting ?
please someone help me ,and my local TimeZone is GMT+08:00
ths very much

ye , i find the solution:
select convert_timezone(‘PST’, ‘+02:00’, ‘2021-04-01 15:27:32’)

1 Like

@yennify Dremio is timezoneless, which means just displays what is stored in the source. You have used the right function to convert to PST