Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version


PostgreSQL 11.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit


create table tab(date_ varchar, time_ varchar)
insert into tab values
('17-07-2022',	'05:00'),
('17-07-2022',	'06:00'),
('17-07-2022',	'10:00'),
('17-07-2022',	'17:00'),
('17-07-2022',	'18:00'),
('18-07-2022',	'17:00')
6 rows affected

select * from tab where concat(date_, ' ', time_)::timestamp <current_timestamp


date_
time_


17-07-2022
05:00

17-07-2022
06:00

17-07-2022
10:00