Date/Time changes while uploading to SnowFlake
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JuliusB
5 - Atom
‎10-29-2020
11:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Date Time
5 REPLIES 5
RobertOdera
13 - Pulsar
‎10-30-2020
09:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎11-03-2020
12:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
No, this doesn't help.
anupama_manme
5 - Atom
‎02-01-2023
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did you solve this? If so, could you please advise.
‎02-02-2023
12:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
NamrataDhiwar
8 - Asteroid
‎07-29-2023
06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can try Snowflake BULK load option while loading data
