[trulysick]

Why won't this query work? I need to query this table then send emails using a job. I've got all the rest down but, this query will not work! I don't get it.

SELECT * 
FROM tech_notif
WHERE send_date = sysdate

Yes there are send_date's with today's date....

I do a

 select sysdate from dual

and it returns the date in the exact format I have it in in the table...
Example 14-JUN-12..

I'm so confused..

NVM I guess I have to use TRUNC(sysdate).... Finally found an answer on google..


CASE CLOSED