Skip to Content
0
Sep 05, 2023 at 05:02 PM

Convert sysdate() to EST

53 Views

Can some one tell me how can i convert UTC sysdate() to EST in SAP BODS within script and store it to a global variable?

i have tried the below approach

sql('LEX_HANA_DS','SELECT current_timestamp AT TIME ZONE \'EST\' "utctolocal" FROM DUMMY');

but it is giving error . in the above i am taking current_timestamp from HANA DB.

Also in the format i only need till HH:MM:SS. millisecond can be ommited.