Issue

• I need to find out the number of months between 2 dates, and also identify when there is an exact number of months between 2 dates. For example:

1-Jan-2012 -> 1-Mar-2012 = exactly 2 months
1-Jan-2012 -> 2-Mar-2012 > 2 months but less than 3 months

In oracle I can use the months_between function that gives me decimal number showing the number of months between 2 dates:

1-Jan-2012 -> 1-Mar-2012 = 2
1-Jan-2012 -> 2-Mar-2012 = 2.03225806451613

The equivalent function in EDS seems to be timestampdiff passing in SQL_TSI_MONTH:

select timestampdiff(SQL_TSI_MONTH,convert('2012-01-01', date),convert('2012-03-01',date))

The problem with this is, according to your documentation, it will always return an Integer. Is this correct as it seems very strange to me that you don't return a decimal.