SYSTIMESTAMP ORACLE in SAP HANA

[former_member383962]

Hi Experts,

In oracle SYSTIMESTAMP RETURNS VALUE AS SHOWN AS BELOW:

SELECT SYSTIMESTAMP FROM DUAL;

SYSTIMESTAMP
------------------------------------------------------------------
28-MAR-00 12.38.55.538741 PM -08:00

HOW CAN I ACHIEVE THE ABOVE RESULTS IN SAP HANA...???

[pfefferf]

Why you cannot use the available timestamp functions in HANA? I guess you read the documentation.

CURRENT_UTCTIMESTAMP

CURRENT_TIMESTAMP

If you cannot use them, then please describe why you cannot use them respectively what you wanna reach.

Regards,
Florian

[bharathyp]

You can run this query:

SELECT CURRENT_TIMESTAMP "current timestamp" FROM DUMMY;

But , it doesn't really tell you the UTC timing.

Some other functions that are available are well documented here.

Datetime Functions