get the first and the last day of current month

[former_SQLA_member1695029]

Hello,

How I get the first and the last day of current month?

[VolkerBarth · Accepted solution]

Do you want to get these as dates? Such as:

select ymd(year(current date), month(current date), 1) as FirstDayOfCurrentMonat,
   cast(dateadd(dd, -1, dateadd(mm, 1, FirstDayOfCurrentMonat)) as date) as LastDayOfCurrentMonth

[former_SQLA_member1695029 · Accepted solution]

Almost

I need to put these information like that:

Select * from Table where date between firstdayofcurrentmonth and lastdayofcurrentmonth

[VolkerBarth · Accepted solution]

For those conditions, I often use the dateformat function:

select * from MyTable
where dateformat(MyDate, 'yyyy/mm') = dateformat(current date, 'yyyy/mm')