那你写个函数吧: CREATE FUNCTION [dbo].[f_dt] (@dt datetime) RETURNS varchar(100) AS BEGIN DECLARE @re VARCHAR(10) set @re=convert(varchar(10),@dt,120) RETURN @re END--测试: create table tb(id int identity(1,1),a datetime) insert into tb select '2004-01-01 21:00:00' union all select '2004-01-02 11:00:00' union all select getdate()select id,[dbo].[f_dt](a)as 日期 from tb drop table tb--运行结果: id 日期 1 2004-01-01 2 2004-01-02 3 2004-09-23
CREATE FUNCTION [dbo].[f_dt] (@dt datetime)
RETURNS varchar(100)
AS
BEGIN
DECLARE @re VARCHAR(10)
set @re=convert(varchar(10),@dt,120)
RETURN @re
END--测试:
create table tb(id int identity(1,1),a datetime)
insert into tb
select '2004-01-01 21:00:00' union all
select '2004-01-02 11:00:00' union all
select getdate()select id,[dbo].[f_dt](a)as 日期 from tb
drop table tb--运行结果:
id 日期
1 2004-01-01
2 2004-01-02
3 2004-09-23