SQLize | PHPize | SQLtest

create table orders( order_id int, order_date date); insert into orders values(1, null); insert into orders values(2, null); insert into orders values(3, TO_DATE('2025-01-12', 'YYYY-MM-DD')); insert into orders values(4, TO_DATE('2025-02-12', 'YYYY-MM-DD')); insert into orders values(5, TO_DATE('2025-03-12', 'YYYY-MM-DD')); create table invoice( invoice_id int, order_id number(5), order_date date); insert into invoice values(1,1, null); insert into invoice values(2,2, TO_DATE('2025-01-12', 'YYYY-MM-DD')); insert into invoice values(3,3, null); insert into invoice values(4,4, TO_DATE('2025-02-12', 'YYYY-MM-DD')); insert into invoice values(5,5, null); select * from invoice where order_date='12-FEB-25'; select * from invoice where order_date=date '2025-02-12';