Hi trafodioneers, It happened that I found Trafodion support both systimestamp and current_timestmap, though systimestamp is not documented in official SQL manual document.
I'd like to make sure is that true that systimestamp represents server timestamp and current_timestamp represents client timestamp? >>select systimestamp from dual; (EXPR) -------------------------- 2018-03-09 18:17:58.534957 --- 1 row(s) selected. >> >> >>select current_timestamp from dual; (EXPR) -------------------------- 2018-03-09 18:18:18.844576 --- 1 row(s) selected. Oracle has such documentation as below, SYSTIMESTAMP returns current timestamp on database server, while current_timestamp returns current timestamp on client machine. So if your database server is in New York and client box is in California, SYSTIMESTAMP will be 3 hours ahead of CURRENT_TIMESTAMP. Best regards, Yuan
