Below is my create and insert queries
create table sample
( id varchar2(256),
reported_date varchar2(256)
)
insert into sample values ('123456','2016-03-18 04:18:56');
insert into sample values ('123456','2016-03-19 04:20:56');
i have 2 params start_date = '01-01-1990' and end_date='01-01-2090'. Both these params are strings.
I need a select the ids where reported_date are in the range of start_date and end_date ( all 3 are in string format).
select id from sample where reported_date between start_date and end_date;
Thanks,