https://delta.io logo
r

Rahul Sharma

08/22/2023, 4:40 AM
Hello everyone, is there any way to save timestamp data without a time zone in Delta Lake? My team is getting confused when they see the UTC timestamp zone suffix in the table. Please suggest a solution. Thank you.
a

Antoine Huret

08/22/2023, 11:22 AM
you can format it as a string. by the way this is a very good habits to explicit the timezone
n

Nick Karpov

08/22/2023, 4:16 PM
if you're using Spark 3.3+, delta 2.4 supports TimestampNTZ data type now (https://github.com/delta-io/delta/releases/tag/v2.4.0, https://docs.delta.io/2.4.0/versioning.html)