Help me with it, I am new in sql queries
You can try the following in SQL
SELECT TRUNC(START_DATE) - TRUNC(CREATED_DATE) DAYS FROM JOB;
I found the Answer in postgresql it is:
select date_part('day',start_time - created_on) as Difference , count(*) from Job
thanks for the replies to all