SQL Query [message #1048] |
Mon, 25 March 2002 20:19 |
Amita Kapadia
Messages: 8 Registered: January 2002
|
Junior Member |
|
|
I want to query data for date range having transactions between specified timing.
|
|
|
Re: SQL Query [message #1053 is a reply to message #1048] |
Tue, 26 March 2002 00:12 |
D e e p a n k a r
Messages: 9 Registered: October 2001
|
Junior Member |
|
|
select * from table
where date between to_date('datecolumn','DD-MM-YYYY HH24:MI:SS') and to_date('datecolumn2','DD-MM-YYYY HH24:MI:SS')
hope this solves the query.
Regards
Deepankar
|
|
|