[SQL] First day of month, last day of month

[Nacef LABIDI]

Hi all,

I want to select data from a table according to a date column in my table. I
want to select all the rows which have date in the current month. So is
there a way to get from the actual date the first day and the last day of
the month or is there a better method to retrieve all the rows with dates in
the current month.

Thanks to all