declare @x table(
    CREATED_AT datetime not null default getdate()
);
insert into @x values(default);
    
select
1
, dateadd(day, datediff(day, 0, CRM_Orders.CREATED_AT), 0) as [Service Order Created At]
, dateadd(month, datediff(month, 0, CRM_Orders.CREATED_AT), 0) as [Service Order Created At Month]
from @x CRM_Orders

cast(stuff(stuff(stuff(cast(CREATED_AT as varchar(17)), 9, 0, ' '), 12, 0, ':'), 15, 0, ':') as datetime)

declare @x table(
    CREATED_AT bigint not null
);
insert into @x values(20090717102705);
    
select
1
, CRM_Orders.CREATED_AT as [Service Order Created At]
, dateadd(month, datediff(month, 0, CRM_Orders.CREATED_AT), 0) as [Service Order Created At Month]
from (
select cast(stuff(stuff(stuff(cast(CREATED_AT as varchar(17)), 9, 0, ' '), 12, 0, ':'), 15, 0, ':') as datetime) as CREATED_AT
from @x
) CRM_Orders;