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(*)
----------
1
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