Shell Programming and Scripting

Ok here is what I have found, the column is date/time data, the EPOC time I receive is 1250909923000. I've found that this is was too many numbers, but when you remove the last 3 "0's" in the string, and compute it, it is the exact time that the job ended in our Prod environment, so the question now is how to you remove the last 3 digits cause I believe it will work. Any suggestions ?

Using bash parameter expansion:

Code:

TIME=1250909923000
# echo ${TIME:0:10}
1250909923

Right but I need to have this done within the sql statement , in the to_char. Thanks for the post

Hi.

As an example:

Code:

select to_char(1234567891000) from dual;
TO_CHAR(12345
-------------
1234567891000
 
 
select substr(to_char(1234567891000), 1, 10) from dual;
 
SUBSTR(TO_
----------
1234567891

try to amend the to_char function like this:

Code:

TO_CHAR(SUBSTR(JOBRUN.ENDTIME, 1, 10), 'HH24:MI:SS MM/DD/YY') from JOB