Re: Is there a function in SQL to calculate days between two dates?

In article <4jebm8$hfe_at_camelot.ccs.neu.edu>, jiang_at_ccs.neu.edu (Hong Jiang) wrote:
>Hi,
>
>I am new in SQL area. Could someone over there tell me there is a function in
>SQL to calculate days between two dates? For example, how many days between
>Jan. 23 1995 and Feb. 1 1996? I haven't found any function calculating days
>directly. I know I could write a pices of program to implement this, but
>I hope if there is such function I can just call.
>
>Thank you very much.
>
>Jiang Hong
SELECT MONTHS_BETWEEN(TO_DATE('02-02-1992', 'MM-DD-YYYY'),

                      TO_DATE('01-01-1992', 'MM-DD-YYYY'))