Calculating 1st date of month

[mindsjrny]

I am looking to find the syntax used for a stored procedure running against an Informix database to calculate the 1st day of the month.

I have where row_date between ''09/01/2005'' AND today-1

What I would like to do is replace having to hard code the beginning date of the month to have the stored procedure to automatically calculate the date.

 

[mberni]

LET firstofmonth = mdy(month(somedate), 1, year(somedate));

should do the job