Date compare

database table values payment_table(id,pay_month) values(1,2007-02-01) (2,2007-03-01)(3,2007-04-01)…etc 89 records.

How do verify column ‘pay_month’ having "ONLY ONE MONTH "difference or not???

  1. what is the datatype of the pay_month column?

  2. which database system is this?

  3. one month difference from what?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.