| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
