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
沒有留言:
張貼留言