Re: Help Regarding Query
From: J.P. <jp_boileau_at_yahoo.com>
Date: 28 Feb 2002 12:42:02 -0800
Message-ID: <7e388bc3.0202281242.23a13af3_at_posting.google.com>
Date: 28 Feb 2002 12:42:02 -0800
Message-ID: <7e388bc3.0202281242.23a13af3_at_posting.google.com>
Hey, that's too easy!! ;)
SELECT TRUNC(DATE_FIELD1) - TRUNC(DATE_FIELD2) FROM TABLE_NAME This assumes that your fields are in the Date format.
Otherwise, wrap the TO_DATE function around them.
JP
prabukrishna_at_hotmail.com (Prabu Krishna) wrote in message news:<4de9020f.0202280724.65b73397_at_posting.google.com>...
> Can any one help me how to get solution that I need a single query to
> find the no of days between two days..
Received on Thu Feb 28 2002 - 21:42:02 CET