SQL query help needed (Oracle)

[c0sie]

Using Oracle SQP*Plus at the moment.

I have two dates in DATE format. I want to know if there is a way of deducting one date from the other (for example START_DATE and FINISH_DATE) to show EXPERIENCE.

Anyone any ideas at all??

Thanks in advance :)

[lochness42]

check this out http://psoug.org/reference/date_func.html
there is example with making diff function on the bottom