date conversion

Hi,
I'm a total newbie and I'm trying to pull data from an Oracle table. I need to convert the date to have hyphens in it but I am getting an error when I do this. Is something blantantly wrong with my syntax?

Code is below.

Thanks,
ew1


SELECT
'|'|| EID,
'|'|| LAST_NAME,
'|'|| FIRST_NAME,
'|'|| TO_CHAR(HIRE_DATE, 'YYYY-MM-DD') AS HIRE_DATE,
'|'|| DEPT_PAY_CHECK,
'|'|| CITY,
'|'|| STATE,
'|'|| ZIP,
'|'|| CAMPUS_PHONE



And the error is:
%RDB-E-EXTFUN|_FAIL, external routine faile|d to compile or execute succe|ssfully|||||
-RDMS-E-RTN_E|RROR, routine "ORA_CVT_TO_CHA|R" generated an error during|execution|||||
-SYSTEM-F-ACC|VIO, access violation, reason| mask=04, virtual address=000|000000000000|0, PC=000|0000001E88C04, PS=0|000001B||

so u want something like: 0002-lastname-firstname..... ?