To_timestamp() and TimeZone?

1

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

image
image1290×235 22.3 KB

but the real time is the under。

image
image701×91 7.72 KB

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

2

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

1 Like
3

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