We are trying to derive the date time from date time stamp field, basically tring to get 6 hours differnce from time stamp field
(TO derive CST time from GMT)
In Oracle we can achieve as below this works from any date time stamp field.
SELECT Sysdate ,sysdate - (6/24) FROM dual
Please let me know if this can be achieved in HANA.