Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to obtain current timestamp

_AZ_Jul 11 2017 — edited Jul 14 2017

Hello,

glad i somehow found the TT specific group..

how do i return current timestamp in the latest and greatest TT?

[code]

select systimestamp from dual;

TT2211: Referenced column SYSTIMESTAMP not found

select timestamp from dual;

TT2211: Referenced column TIMESTAMP not found

SELECT to_char(sysdate,'YYYY-MON-HH24 MI:SS.ff6') FROM DUAL;

2017-JUL-18 23:11.000000

[/code]

the sysdate predictable returns (date) time rounded to the last second.

there is no Oracle DB backend, just TT with a few tables i'm trying to populate with data.

thank you

P.S Version if that matters:

ttversion

TimesTen Release 11.2.2.8.0 (64 bit Linux/x86_64) (tt1122:53396) 2015-01-20T08:36:31Z

Instance admin: az

Instance home directory: /home/az/TimesTen/tt1122

Group owner: az

Daemon home directory: /home/az/TimesTen/tt1122/info

PL/SQL enabled.

This post has been answered by Gaz in Oz on Jul 11 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2017

Added on Jul 11 2017

#database-key-features, #timesten-in-memory-database

6 comments

3,507 views