sql*plus or pl/sql question

[bradleyc]

How would you calculate the difference between two dates?

[bradleyc]

Apparently i should use DATEDIFF ... how do i use DATEDIFF?

[Ejaz]

DateDiff Function (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsfctdatediff.asp)

[trends]

hi ,

try this.

datediff( 'mm', d1, d2 ).where mm is month.for date you give dd.ok