从Essential SQL Server日期,时间和DateTime函数中尝试使用TimeOnly函数:
create function TimeOnly(@DateTime DateTime)
returns datetime
as
begin
return dateadd(day, -datediff(day, 0, @datetime), @datetime)
end
go
或简单地将DateTime转换为sql Server 2008中的时间:
declare @time as time
set @time = cast(dateTimeVal as time)