Regarding calculation of date difference in oracle

I have a table which consist of column like movies ,date etc and i have to find difference of date in movies watch please specify the query t开发者_如何学Pythonhanks

Oracle has native support for date arithmetic. You can subtract one date from another - e.g. SELECT SYSDATE - date_watched FROM movies_table will return a the number of days between today's date and date_watched.

You need to provide more detail about your requirements for a more exact answer - e.g. table structure, sample data, expected output.