Sunday, November 28, 2010

Postgres Query to find difference between months

select ( date '2010-01-01', interval '4 months') overlaps 
 ( date '2010-04-30', date '2010-04-30') as flag
This Query  returns true if difference between months is 4 or less than 4 months 
in postgresql and returns false if difference is morethan 4 months

No comments:

Post a Comment