Write a query to display the number of months between September 29, 1999 and August 17, 2003?

0 ⤊

In oracle SQL

2007-01-28 16:36:32 · 2 answers · asked by shumonicagraham 2 in Computers & Internet ➔ Programming & Design

SELECT MONTHS_BETWEEN (TO_DATE ('29-09-1999','DD-MM-YYYY'), TO_DATE ('17-08-2003','DD-MM-YYYY'))

2007-01-28 20:21:36 · answer #1 · answered by Cribbage 5 · 0⤊ 0⤋

In SQL Server you can write to get answer to your question

SELECT datediff(mm, '19990929', '20030817' )

2007-01-29 05:23:44 · answer #2 · answered by Serge M 6 · 0⤊ 0⤋