- 12672 Views
- 3 replies
- 9 kudos
Hello! I have the following problem. I want to save the delta table and that table contains timestamp columns, but when I try to write that table with spark the timestamp columns become timestamp with the time zone. This is a problem in my case becau...
- 12672 Views
- 3 replies
- 9 kudos
Latest Reply
Hi @Hubert Dudek ,When you have time, I describe my problem. Can you please check?
2 More Replies
by
Mado
• Valued Contributor II
- 2826 Views
- 1 replies
- 1 kudos
Hi, I want to change the default time zone for SQL Warehoue in the SQL Persona. When I try to Edit the SQL warehouse settings in the "SQL Warehouses" section, I am not able to find any setting where I can set the time zone. I am aware that I can set ...
- 2826 Views
- 1 replies
- 1 kudos
Latest Reply
Mado
Valued Contributor II
Thanks. I am aware of the SET TIME ZONE command but I need to run this command every time I start the SQL warehouse. I am looking for a way to change the default time zone of the SQL warehouse. Something like "spark.sql.session.timeZone GMT+10" that ...
- 7786 Views
- 6 replies
- 33 kudos
Today I was working in Timezone kind of data but my Singapore user want to see their time in the Data and USA user want to see their time in the datainstead of both, we all are getting UTC time,how to solve this issuePlease guide Data can be anything...
- 7786 Views
- 6 replies
- 33 kudos
Latest Reply
I got it guys it was happening due to a library conflict now your answers are really helpful I tried all things
5 More Replies
- 3149 Views
- 1 replies
- 0 kudos
How to change the time zone in notebook ,
- 3149 Views
- 1 replies
- 0 kudos
Latest Reply
import java.util.TimeZone spark.conf.set("spark.sql.session.timeZone", "Asia/Calcutta")TimeZone.setDefault(TimeZone.getTimeZone("Asia/Calcutta"))Scalaimport java.timeval s: String = time.LocalDateTime.now().toStringprintln(s)sql %sqlselect current_t...
