Re: Is there a function in SQL to calculate days between two dates?
From: Geoff Ingram <ingramg_at_boat.bt.co.uk>
Date: 1996/03/29
Message-ID: <4jh49m$mmb_at_pheidippides.axion.bt.co.uk>#1/1
All my own personal opinions Received on Fri Mar 29 1996 - 00:00:00 CET
Date: 1996/03/29
Message-ID: <4jh49m$mmb_at_pheidippides.axion.bt.co.uk>#1/1
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
subtract two dates and the value is a decimal giving days between the dates.
ie select date1-date2 from table;
>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
regards Geoff Ingram
All my own personal opinions Received on Fri Mar 29 1996 - 00:00:00 CET