Skip to Content
0
Feb 26, 2021 at 12:02 PM

UTCTOLOCAL Function in SAP HANA

167 Views

Hello Experts,

I want to use UTCTOLOCAL Function to convert a time into UTC+5:30.

For example,

SELECT UTCTOLOCAL ('2021-01-28 13:51:55', 'UTC+5:30')
FROM DUMMY

It works for UTC+1, UTC+2, UTC-1, UTC-2 and so on. But it get stucks for UTC+5:30.

Could you help me how to give the timezone in case of UTC+5:30?

Thank You.

Best Regards,

Ajinkya Jadhav