Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
488 Points
720 Posts
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'
fralo
Member
488 Points
720 Posts
Query 'where' between Sysdate and first day of month
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'
"They just ARRRGGGHHHH!!!!!"