You should try to replace:
select count(distinct TASK_START_DATE) from prof_tasks
inner join prof_employee_data on prof_employee_data.employee_id = prof_tasks.employee_id
where prof_employee_data.emp_code= '12411'
and extract(month from to_date(TASK_START_DATE,'dd/mm/yyyy')) = '01/10/2016'
and extract(year from to_date(TASK_START_DATE,'dd/mm/yyyy'))='01/10/2016'
and allownce_id = 1
by:
select count(distinct TASK_START_DATE) from prof_tasks
inner join prof_employee_data on prof_employee_data.employee_id = prof_tasks.employee_id
where prof_employee_data.emp_code= '12411'
and extract(month from to_date(TASK_START_DATE,'dd/mm/yyyy')) = 10
and extract(year from to_date(TASK_START_DATE,'dd/mm/yyyy'))= 2016
and allownce_id = 1
Quote:
i want make the format date is complete like 01/10/2016 how i do that
I don't understand this!
Use
Improve question to update your question.
Note that the comments are not working probably for the WE. I can see the comment but not answer.