Home » SQL & PL/SQL » SQL & PL/SQL » Find No Of Days Between Two Dates
Find No Of Days Between Two Dates [message #359671] Mon, 17 November 2008 23:46 Go to next message
Messages: 11
Registered: August 2007
Junior Member
hello and hi
me have a data base given below
me want to find no of days between '16-oct-2008' and '02-NOV-2008'

Emp Start_Date End_Date

25551 10/16/2008 10/30/2008
25551 10/31/2008 11/30/2008

any body help me pls


Re: Find No Of Days Between Two Dates [message #359707 is a reply to message #359671] Tue, 18 November 2008 01:03 Go to previous message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- (minus) gives you the number of days bewteen 2 dates.
SQL> select to_date('25/12/2008','DD/MM/YYYY')-trunc(sysdate) days_to_christmas from dual;

1 row selected.

Previous Topic: Select Rows as Columns
Next Topic: "if condition" and "how to get output" (merged)
Goto Forum:

Current Time: Thu Aug 17 16:43:53 CDT 2017

Total time taken to generate the page: 0.09644 seconds