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.