| Rush |
Posted: Feb 21, 2007 12:27:41 AM |
Total Post: 127
Joined: Jan, 2007
|
is there anybody to help me to find rows betwn two dates?
there is no sufficient answer on the net.plz favour me on gullu02@gmail.com |
|
|
 Vigyan |
| Posted: Feb 21, 2007 10:26:47 AM |  |
|
Total Post: 386
Joined: May, 2001
|
Have you tried between function?
e.g.
select * from table_name where date_column between 'first_date' and 'last_name' ;
Vigyan
|
|
|
|
|
| Vigyan |
| Posted: Feb 21, 2007 10:27:10 AM | |
|
Total Post: 386
Joined: May, 2001
|
Sorry..
select * from table_name where date_column between 'first_date' and 'last_date' ;
|
|
|
|
|
| Rush |
| Posted: Feb 21, 2007 10:46:36 PM | |
|
Total Post: 127
Joined: Jan, 2007
|
hi vigyan a have solved that date function problem like this
select * from emp where to_date(hiredate,'formate')between to_date('date','formate')and to_date('date','formate');
|
|
|
|
|
| Vigyan |
| Posted: Feb 22, 2007 11:39:59 AM | |
|
Total Post: 386
Joined: May, 2001
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
