SELECT * FROM tech_notif WHERE send_date = sysdate
Yes there are send_date's with today's date....
I do a
select sysdate from dualand it returns the date in the exact format I have it in in the table...
I'm so confused..
NVM I guess I have to use TRUNC(sysdate).... Finally found an answer on google..