Math on date timestamp field

[Former Member]

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!

[lbreddemann · Accepted solution]

Hi Ravi,

please don't cross post... I answered your question in .

regards,

Lars

[hai_murali_here]

Hi,

Can you give the Example like whats your input time and expected output time to get it clearly?

Rgds,

Murali