|
|
Posted by Rik on 06/07/06 17:26
wesley@ispace.co.za wrote:
> Hi All, what date format does the PERIOD_DIFF use?
> Thanks Wes
RTFM:
PERIOD_DIFF(P1,P2)
Returns the number of months between periods P1 and P2. P1 and P2 should be
in the format YYMM or YYYYMM. Note that the period arguments P1 and P2 are
not date values.
mysql> SELECT PERIOD_DIFF(9802,199703);
-> 11
Grtz,
--
Rik Wasmus
Navigation:
[Reply to this message]
|