Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Mar 23, 2010 02:13 PM|LINK
Do any of you guys know of a simple where clause to return values between the current SYSDATE and the first day of the month? Like...
SELECT * FROM TABLE WHERE DATE_FIELD BETWEEN SYSDATE AND 'FIRST DAY OF THE MONTH'