This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Snaplogic Generic JDBC

Jarek
New Contributor

‎11-04-2021 04:43 AM

Hello,

I’m having a small problem with the timestamp between the results coming from Snaplogic Generic JDBC and SQL Teradata SQL assistant.

Main issue is that the timestamp in Snaplogic results shows a different time compared to Teradata SQL assistant. Could you please let me know what I need to change on the Snaplogic side in order to match the timestamp results. Same query used in both places. The format is irrelevant just want to have same date and time e.g. 1st of OCT 2021 00:00:07 instead of 05:00:07 (as in Snaplogic results).

Best Regards,
Jarek
snap

sql

0 Kudos
2 REPLIES 2

bojanvelevski
Valued Contributor

‎11-04-2021 04:57 AM

Hi @Jarek,

This sounds like a Collation issue. Check if there’s a Url setting added in the account you are using in the JDBC snaps.

0 Kudos

Jarek
New Contributor
In response to bojanvelevski

‎11-04-2021 05:05 AM

Hi @bojanvelevski

This is what I have in the account settings. Is there a way to add e.g. UTC format or something similar?

jdbc:teradata://tdwd/TMODE=ANSI,CHARSET=UTF8

BR,
Jarek

0 Kudos