2009-01-18

Calendar date interval 日曆年月日時段計算

Oracle
Months_between( date1, date2 )
DAYS_BETWEEN('1996-03-01', '1996-02-28')

MS Access
DateDiff()
DateDiff ("yyyy", #15/10/1998#, #22/11/2003#) would return 5
DateDiff ("m", #15/10/2003#, #22/11/2003#) would return 1
DateDiff ("d", #15/10/2003#, #22/11/2003#) would return 38

沒有留言: