'snowflake timezone convert function is not converting

I am reading times from a snowflake DB in UTC/GMT, for example as

2021-12-14T18:11:32.753+00:00
2021-12-18T18:11:10.529+00:00
2021-12-20T00:02:02.781+00:00

I want to convert these to AEST(GMT+11), so I use the following statement: convert_timezone('Australia/Melbourne', artifact_generated_at) as time2

But this seems to only convert the time zone component and doesn't actually convert the time.

2021-12-14T18:11:32.753+11:00
2021-12-18T18:11:10.529+11:00
2021-12-20T00:02:02.781+11:00

any thoughts? or should I be using a different function?



Solution 1:[1]

I used CONVERT_TIMEZONE('UTC', 'Australia/Melbourne', artifact_generated_at) which worked fine.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 GenDemo