psql:triggertest.txt:58: ERROR: syntax error at or near "02" at
character 81
QUERY: update emp_tmp set empname = jjh1, salary = 300 ,last_date
= to_date(2005-08-02 02:00:00 ,YYYY-MM-DD HH24:MI:SS)::timestamp
,last_user = lbs where empname = jjh1
CONTEXT: PL/pgSQL function "emp_change" line 16 at execute
statement
psql:triggertest.txt:58: LINE 1: ...jh1, salary = 300 ,last_date =
to_date(2005-08-02 02:00:00 ,...
psql:triggertest.txt:58:
^
어떤 에러인지 이해가 안됩니다..
날짜타입 변환에 어떤 문제가 있는 건지요..
|