6일차 # 3-42: fx의 효과

SQL> select last_name, hire_date

    from employees

    where hire_date = to_date('June  7, 2002', 'fxMonth DD, YYYY');

==> ERROR : ORA-01858: a non-numeric character was found where a numeric was expected

SQL> l

 1    select last_name, hire_date

 2    from employees

 3*   where hire_date = to_date('June  7, 2002', 'fxMonth DD, YYYY')

SQL> c/June  7/June 7

 3*   where hire_date = to_date('June 7, 2002', 'fxMonth DD, YYYY')

SQL> /

 where hire_date = to_date('June 7, 2002', 'fxMonth DD, YYYY')

==> ERROR : ORA-01862: the numeric value does not match the length of the format item

SQL> l

 1    select last_name, hire_date

 2    from employees

 3*   where hire_date = to_date('June 7, 2002', 'fxMonth DD, YYYY')

SQL> c/7/07

 3*   where hire_date = to_date('June 07, 2002', 'fxMonth DD, YYYY')

SQL> /

↓ ↓ ↓ 

  * 결론: fx를 사용하면 format element 간의 공백과 자릿수를 맞춰주어야 합니다.

                    (June  7 => June 7, 7 => 07)

※으아...집에서 하니까 안되네...강사님도 여러번 하셨는데... 아무튼 자릿수를 잘 맞춰라~~

oj_SQL.txt