Hey all,
I am uploading datetime field to Snowflake (timestamp_ntz) and end up with all values changed by 7 hours.
I believe an error is with timezones, but isn't that possible to have something like naive datetime in Alteryx? Using datetimeadd() sounds not like an option here.
Thanks a lot,
Julius
Hi, @JuliusB
Can you try all of the below and see if it works?
- DateTimeToLocal([timestamp_ntz])
It should convert to the local system timezone.
Cheers.
Hi,
No, this doesn't help.
Did you solve this? If so, could you please advise.
Hi, @anupama_manme . Actually do not recall as this was long time ago. But DATETIME_NTZ datatype in Snowflake and forced entry as STRING from Alteryx should work.
You can try Snowflake BULK load option while loading data