Current_date returns in UTC timezone

1

Hi , I am running the below query in Dremio client and my system timezone is IST.
Below is the scenario
Query ran on 7/11/2025 12:33 AM IST
select current_date
Query output is 7/10/2025

How can i get Dremio return 7/11/2025 ?

2

@pakiran CURRENT_DATE returns UTC, can you try using CONVERT_TIMEZONE` SQL function?

3

Hi Balaji , I did try. I am in IST and tried executing the below query
convert_timezone(‘UTC’,‘HKT’,current_date) around 12:30 AM IST on 7/11/2025 but i was getting output as 7/10/2025 8:00 AM. Ideally i was expecting output as 7/11/2025 3:00 AM HKT. Request you to please check and assist.

Thanks
Kiran