0 Replies - 5080 Views - Last Post: 14 June 2012 - 10:32 AM

#1 trulysick  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 17
  • Joined: 03-August 11

Help with using sysdate in where clause

Posted 14 June 2012 - 10:32 AM

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

Is This A Good Question/Topic? 0
  • +

Page 1 of 1