Hi All, im new to SQL
I have a field which has a date called RM_JOB.ACTUAL_COMPLETION_DATE
in the database if a job is not completed it shows a date of 01/01/9999
What I want to be able to do is leave the date in the database alone but when I run a query if the field = 01/01/9999 then null else the actual completeion date.
Is this possible? If so is it easy to do?
thanks in advance
David.
I have a field which has a date called RM_JOB.ACTUAL_COMPLETION_DATE
in the database if a job is not completed it shows a date of 01/01/9999
What I want to be able to do is leave the date in the database alone but when I run a query if the field = 01/01/9999 then null else the actual completeion date.
Is this possible? If so is it easy to do?
thanks in advance
David.