declare @a table(dat datetime) insert into @a select '2012-4-30' union all select '2012-1-31' select * from @a update @a set dat=(replace(dat,datepart(day,cast((convert(varchar(10),dat,111)) as datetime)),'26') ) select * from @a
--保留到微妙 update A set Date=CONVERT(VARCHAR(7),Date,121)+'-26 '+CONVERT(VARCHAR(12),Date,114) where day(Date)<>26 --只到日期 update A set Date=CONVERT(VARCHAR(7),Date,121)+'-26' where day(Date)<>26
UPDATE TB
SET DATE=CONVERT(VARCHAR(7),DATE,120)+'-26'
WHERE DATE IN(SELECT MAX(DATE) FROM TB T WHERE DATEDIFF(MM,T.DATE,TB.DATE)=0)
a
set
date=convert(varchar(7),date,120)+'-26'
where
date=(select max(date) from tb)
WHERE date=(SELECT MAX(date) FROM A)
declare @a table(dat datetime)
insert into @a select '2012-4-30'
union all select '2012-1-31'
select * from @a
update @a set dat=(replace(dat,datepart(day,cast((convert(varchar(10),dat,111)) as datetime)),'26') )
select * from @a
--保留到微妙
update A
set Date=CONVERT(VARCHAR(7),Date,121)+'-26 '+CONVERT(VARCHAR(12),Date,114)
where day(Date)<>26
--只到日期
update A
set Date=CONVERT(VARCHAR(7),Date,121)+'-26'
where day(Date)<>26