Member Avatar for veledrom

Hi,

I can not use below code in stored proc in oracle;

IF (SYSDATE = '04-MAY-08') THEN
...
END IF;

This doesn't work either way (true or false).

Is there any other way to check it?

thanks

  • 1 Contributor
  • 1 Reply
  • 80 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by veledrom
Member Avatar for veledrom

USE trunc(sysdate) INSTEAD

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.