CREATE FUNCTION ConvertDateFormat() RETURNS NVARCHAR(50) AS BEGIN DECLARE @hourCount int DECLARE @minuteCount int DECLARE @minute int set @minuteCount = datediff(mi,'1900-01-01','1900-01-02 07:29:00') set @hourCount = floor(@minuteCount/60) set @minute = floor(@minuteCount%60) RETURN @hourCount+':'+@minute END调用这个function
/*
-----------
31(1 行受影响)
*/
select datediff(hh,'1900-01-01','1900-01-02 07:29:00')
能读到小时分钟数
':'+CONVERT(CHAR(2),datediff(mi,'1900-01-01','1900-01-02 07:29:00')%60)
/*
-------------
31:29(1 個資料列受到影響)
*/
seselect ltrim(datediff(mi,'1900-01-01','1900-01-02 07:29:00')/60)
+ ':' + ltrim(datediff(mi,'1900-01-01','1900-01-02 07:29:00')%60)
/********
-------------------------
31:29(1 行受影响)
CREATE FUNCTION ConvertDateFormat()
RETURNS NVARCHAR(50)
AS
BEGIN
DECLARE @hourCount int
DECLARE @minuteCount int
DECLARE @minute int
set @minuteCount = datediff(mi,'1900-01-01','1900-01-02 07:29:00')
set @hourCount = floor(@minuteCount/60)
set @minute = floor(@minuteCount%60)
RETURN @hourCount+':'+@minute
END调用这个function