Date conversion error
SQL> select TO_DATE(' 2010-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') from dual;
TO_DATE('
---------
01-FEB-10
SQL> get c
1 declare
2 high_val varchar2(200) := 'TO_DATE('' 2010-02-01 00:00:00'', ''SYYYY-MM-DD HH24:MI:SS'', ''NLS_CALENDAR=GREGORIAN'')';
3 date_val date ;
4 begin
5 dbms_output.put_line('This is high val '||high_val);
6 date_val := to_date(high_val,'DD-MON-YY') ;
7 --dbms_output.put_line(date_val);
8* end;
9 /
This is high val TO_DATE(' 2010-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')