declare @a datetime
set @a = '2009-1-1'
declare @b nvarchar(10)
set @b = convert(nvarchar(10),@a,120)
print @b
输出:
2009-01-01
declare @a datetime
set @a = '2009-1-1'
declare @b nvarchar(10)
set @b = convert(nvarchar(10),@a,120)
print @b
输出:
2009-01-01