how to calculate month difference from two different columns in Sql Developer?

4347 views sql
-2

I want to calculate month difference in same table from 2 different columns. In other words, I have 2 different columns that include dates and I would like to see their month difference in Sql Developer. Is there any way to do that?

Thank you.

answered question

which database ? oracle or mssql ?

Oracle. im trying to do it sql developer now

1 Answer

9

for mysql : The DATEDIFF function can give you the number of days between two dates.

for oracle: months_between

posted this

Have an answer?

JD

Please login first before posting an answer.