taking dates before end of the month in sql code example

Example: sql end of month

EOMONTH(start_date [, offset] );