Create local date-time from years, months, days, hours, mins, secs fields. Alternatively, try to create local date-time from date and time fields. If the configuration spark.sql.ansi.enabled is false, ...

Converts a timestamp that is timezone-agnostic (interpreted as a UTC timestamp) to a timestamp in the given time zone. This is a common function for databases supporting TIMESTAMP WITHOUT TIMEZONE.