Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql query filtering data with date time

teefu ghulamMay 2 2021

dear members
using oracle database 10gR2
data field is recorded as datetime.
now how can i retrieve data by using sql query like
select * from table
where je_date between '25 APR 2021 12:13' AND '25-APR-2021 15:00'
/
data.jpgtable structure.txt (293 Bytes)
Comments
Post Details
Added on May 2 2021
2 comments
4,002 views
1 mention