CREATE FUNCTION uf_CDate_API(@sDatetime VARCHAR(20)) RETURNS VARCHAR(20) AS BEGIN DECLARE @sDate VARCHAR(20)--这里是不是得增加字符串长度? SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' + CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' + CAST(Day(@sDatetime) AS VARCHAR(2)) +' '+cast(hour,@sDatetime)+':'+cast(minute,@sDatetime)++':'+cast(second,@sDatetime)--为啥我用Hour不变色?求各位高手帮忙补全~ RETURN (@sDate) END
CREATE FUNCTION uf_CDate_API(@sDatetime VARCHAR(20)) RETURNS VARCHAR(10) AS BEGIN DECLARE @sDate VARCHAR(10)--这里是不是得增加字符串长度? SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' + CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' + CAST(Day(@sDatetime) AS VARCHAR(2))+' '+rtrim(datepart(hh,@sDatetime)+':'+ rtrim(datepart(mi,@sDatetime))+':'+rtrim(datepart(ss,@sDatetime))--为啥我用Hour不变色?求各位高手帮忙补全~ RETURN (@sDate) END
最后的答案:CREATE FUNCTION uf_CDate_API(@sDatetime VARCHAR(20)) RETURNS VARCHAR(20) AS BEGIN DECLARE @sDate VARCHAR(20) SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' + CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' + CAST(Day(@sDatetime) AS VARCHAR(2))+' '+CAST(datepart(hh,@sDatetime)AS Varchar(2))+':'+ CAST(datepart(n,@sDatetime) as varchar(2))+':'+Cast(datepart(ss,@sDatetime) as varchar(2)) RETURN (@sDate) END谢谢各位大虾
select replace(convert(varchar(19),getdate(),120),'-0','-')2011-3-29 11:30:24
RETURNS VARCHAR(20) AS
BEGIN
DECLARE @sDate VARCHAR(20)--这里是不是得增加字符串长度?
SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' + CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' + CAST(Day(@sDatetime) AS VARCHAR(2))
+' '+cast(hour,@sDatetime)+':'+cast(minute,@sDatetime)++':'+cast(second,@sDatetime)--为啥我用Hour不变色?求各位高手帮忙补全~
RETURN (@sDate)
END
select replace(replace(replace(convert(varchar(19),getdate(),120),'-0','-'),' 0',' '),':0',':')2011-3-29 11:51:7
RETURNS VARCHAR(10) AS
BEGIN
DECLARE @sDate VARCHAR(10)--这里是不是得增加字符串长度?
SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' +
CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' +
CAST(Day(@sDatetime) AS VARCHAR(2))+' '+rtrim(datepart(hh,@sDatetime)+':'+
rtrim(datepart(mi,@sDatetime))+':'+rtrim(datepart(ss,@sDatetime))--为啥我用Hour不变色?求各位高手帮忙补全~
RETURN (@sDate)
END
select ltrim(datepart(yy,getdate()))+'-'+ltrim(datepart(mm,getdate()))
+'-'+ltrim(datepart(dd,getdate()))+' '+ltrim(datepart(hh,getdate()))
+':'+ltrim(datepart(mi,getdate()))+':'+ltrim(datepart(ss,getdate()))/*2011-3-29 11:54:1
+'-'+ltrim(datepart(dd,getdate()))+' '+ltrim(datepart(hh,getdate()))
+':'+ltrim(datepart(mi,getdate()))+':'+ltrim(datepart(ss,getdate()))
RETURNS VARCHAR(20) AS
BEGIN
DECLARE @sDate VARCHAR(20)
SET @sDate = Cast(Year(@sDatetime) as varchar(4)) +'-' +
CAST(Month(@sDatetime) AS VARCHAR(2)) + '-' +
CAST(Day(@sDatetime) AS VARCHAR(2))+' '+CAST(datepart(hh,@sDatetime)AS Varchar(2))+':'+
CAST(datepart(n,@sDatetime) as varchar(2))+':'+Cast(datepart(ss,@sDatetime) as varchar(2))
RETURN (@sDate)
END谢谢各位大虾