How do I get the date of the earliest Wednesday starting from sysdate (inclusive of Sysdate)???
Example today is Feb 6, 2007 and it's a Wendesday, so I should return 06-Feb-2007. But if today is 08-Feb-2007, I should return Feb 14 2007.
Can you please help me write the query?? Thanks.