HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

How to get the month difference between 2 Date	Gib Hsu	2010-05-22 07:18:23
Hi Support, I have a question. I f I want to know the month difference between given 2 days. For example, the difference between any date in Jan 2010 and any date in May 2010, I should get the result 4. Thanks.
Re:How to get the month difference between 2 Date	HXTT Support	2010-05-22 08:23:51
Try month(date1)-month(date2) or TIMESTAMPDIFF(DAY, timestamp1, timpestamp2) at Date/Time Functions

Email: