declare @dd_dateDa datetime,@dd_dateST datetime
set @dd_dateDa='2004-05-31 1:00:01'
set @dd_dateST=@dd_dateDa
select convert(varchar(10),@dd_dateST,120)
set @dd_dateDa='2004-05-31 1:00:01'
set @dd_dateST=@dd_dateDa
select convert(varchar(10),@dd_dateST,120)
例如:select ),@dd_dateST=Getdate()
select convert(varchar(10),@dd_dateST,120)也可以?
后),@dd_dateST没有变化啊
declare @dd_dateDa datetime,@dd_dateST datetime
set @dd_dateDa='2004-05-31 1:00:01'
set @dd_dateST=@dd_dateDa
select convert(varchar(10),@dd_dateST,120)/*
-------------
2004-05-31*/
set @dd_dateDa='2004-05-31 1:00:01'
set @dd_dateST=convert(varchar(10),@dd_dateST,120)
declare @dd_dateDa datetime,@dd_dateST datetime
set @dd_dateDa='2004-05-31 1:00:01'
set @dd_dateST=convert(varchar(10),@dd_dateDa,120)