Skip to Content
0
Former Member
Mar 02, 2012 at 09:18 PM

Math on date timestamp field

30 Views

Hello,

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.

Thanks!