extract year, month, 1st date of the month

Question

Hi Expert,

I want to extract year, month, 1st date of the month using only extract function or adddate

create tab1
(col1, date)

insert into tab1
values('02/02/2022')

col1
02/02/2022

expected output
01/02/2022(dd/mm/yyy)

Regards

Answer 1

At minimum before you post, you need to test your own script.
create table tab1
(col1 int, date date)

insert into tab1  
values(1,'02/02/2022')  
select * , format(date,'01/MM/yyyy') firstofMonthddMMyyyy   
from tab1  
  
--or  

select * , try_convert(varchar(10),dateadd(day,1,eomonth(date,-1)),103) firstofMonthddMMyyyy
from tab1

drop table tab1  

Answer 2

Please see:

https://www.mssqltips.com/sqlservertip/6088/simplify-date-period-calculations-in-sql-server/