| date problem [message #275581] |
Sun, 21 October 2007 22:44  |
fam_bila
Messages: 43
Registered: August 2007
Location: pakistan
|
Member |
|
|
hi,
my problem is
i want to select dates between two dates
for this if i use function
"subtract two dates"
then what should be in select and from clauses.
is there anyother method to find it.
thanx
[Updated on: Sun, 21 October 2007 22:46] Report message to a moderator |
|
|
|
|
|
|
|
| Re: date problem [message #275595 is a reply to message #275589] |
Mon, 22 October 2007 00:12  |
fam_bila
Messages: 43
Registered: August 2007
Location: pakistan
|
Member |
|
|
If i use between in where clause then what should be in select and from clauses
select .....
from .....
where ..... between '17-oct-2007' and '22-oct-2007'
as data(dates) are not selected from any user table.
|
|
|
|
| Re: date problem [message #275600 is a reply to message #275595] |
Mon, 22 October 2007 00:51 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I do not understand the problem that you are trying to solve! Select the fields that you want from the table in which they reside.
Also, '17-oct-2007' is not a DATE. It is the string representation of a DATE. Use 'to_date' to turn your strings into usable date fields.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
