topic Re: CONVERT_TIMEZONE issue in DLT in Get Started Discussions

CONVERT_TIMEZONE issue in DLT

SamGreene — Sun, 17 Dec 2023 02:02:40 GMT

I can run a query that uses the CONVERT_TIMEZONE function in a SQL notebook. When I move the code to my DLT notebook the pipeline produces this error:

Cannot resolve function `CONVERT_TIMEZONE`

Here is the line: CONVERT_TIMEZONE('UTC', 'America/Phoenix', date_time) as local_datetime

Should this work?

Re: CONVERT_TIMEZONE issue in DLT

SamGreene — Wed, 17 Jan 2024 00:44:02 GMT

Can anyone replicate this? Thanks.

Re: CONVERT_TIMEZONE issue in DLT

annn — Sun, 24 Mar 2024 00:34:26 GMT

I'm having this exact same issue. @SamGreene did you ever find a resolution to this?

Re: CONVERT_TIMEZONE issue in DLT

Danny_Lee — Sun, 24 Mar 2024 02:27:42 GMT

Have you added

%sql

magic command?

Also, did you SELECT the CONVERT_TIMEZONE?

> SELECT convert_timezone('America/Los_Angeles', 'UTC', timestamp_ntz'2021-12-06 00:00:00'); 2021-12-06 08:00:00 -- Current session local timezone: UTC > SELECT convert_timezone('America/Los_Angeles', timestamp_ntz'2021-12-06 08:00:00');; 2021-12-06 00:00:00

From docs: https://docs.databricks.com/en/sql/language-manual/functions/convert_timezone.html

Re: CONVERT_TIMEZONE issue in DLT

annn — Sun, 24 Mar 2024 02:34:33 GMT

Yes, the notebook is set to SQL and the convert_timezone function is within a select statement.

Re: CONVERT_TIMEZONE issue in DLT

SamGreene — Sun, 24 Mar 2024 03:31:52 GMT

Yes, Danny, this is in an otherwise functional DLT SQL notebook. It happens when I add the function around an existing column being selected.