Sorry, Not looking for a way to extract a month from a timestamp. I'm
looking for a way to convert an interval from days to months. I'm not
sure after digging into it that there is a way to handle it in SQL, as
the interval that results from subtracting one timestamp from another is
not away
I'm still not sure what you were looking for.
If you have, say, March 16th, and the next date is August 23rd, do you
want to count March, April, May, Jun, July, August = 6? Or do you want to
count the number of 30 day periods?
Using date_part gets you the first one.
Plus, since months can be