Shell Programming and Scripting

Gives me this error
ERROR at line 1:
ORA-01481: invalid number format model
When I use the code with date format, Here is my code that is getting errors

#!/usr/bin/sh


sqlplus -S username/password@MYDATABASE <<eof> myfile
set heading off feedback off verify off
select JOB.JOBNAME, to_char(JOBRUN.ENDTIME, 'HH24:MI:SS MM/DD/YY') from JOB, JOBRUN where JOB.JOBID = JOBRUN.JOBID and JOB.JOBNAME in ('myjob1');
exit


EOF
‘

Can you describe the table JOBRUN - is the ENDTIME column a date type?

Jobrun table does hold run time columns and the endtime column holds the time the job end time.

what is the datatype of the endtime column?
the error indicates it most likely isn't date

This is date datatye
Here is a link to what the error code is about
ORA-01481: invalid number format model

I'm trying to reread SQL info to get the correct syntax

Not sure the last post was handled as it had a link, but here is the cause of the error code from a website

Cause: The user is attempting to either convert a number to a string via TO_CHAR or a string to a number via TO_NUMBER and has supplied an invalid number format model parameter.

The datatype is a TIME stamp (numbers), I'm rereading SQL data formatting now

---------- Post updated at 07:04 PM ---------- Previous update was at 06:56 PM ----------

correct my last post as the data is a time stamp (numeric)

the TO_CHAR function accepts both DATE and TIMESTAMP datatypes and shouldn't produce this error for those types.

what output does the following produce:

Code:

select data_type from user_tab_columns where column_name = 'JOBRUN.ENDTIME';