Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-08186 invalid timestamp

supersenApr 5 2020 — edited Apr 5 2020

Hi all

Please help currently i am working o flashback query

create table fq(id number);

select current_scn,to_char(systimestamp,'YYYY-MM-DD HH24:MI:SS') from v$DATABASE

SQL> /

CURRENT_SCN TO_CHAR(SYSTIMESTAM

----------- -------------------

4578760 2020-04-05 14:45:34

SQL> select count(*) from fq;

COUNT(*)

----------

SQL>

select count(*) from fq AS OF TIMESTAMP TO_TIMESTAMP('05-APR-20 14:45:34','DD-MON-RR HH24:MI:SS');

ORA-08186: invalid timestamp specified

what went wrong here

SQL> show parameter nls_date

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

nls_date_format string DD-MON-RR

nls_date_language string AMERICAN

SQL> show parameter nls_time

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

nls_time_format string HH.MI.SSXFF AM

nls_time_tz_format string HH.MI.SSXFF AM TZR

nls_timestamp_format string DD-MON-RR HH.MI.SSXFF AM

nls_timestamp_tz_format string DD-MON-RR HH.MI.SSXFF AM TZR

Please help

Supersent

Added on Apr 5 2020

#general-database-discussions

6 comments

3,885 views