1,新增转换时间为毫秒函数(转载)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: GGA
-- Create date: 2013-03-28
-- Description: 将时间类型转化成BIGINT,返回指定时间
-- 到-01-01 08:00:00.000的毫秒数
-- =============================================
CREATE FUNCTION [dbo].[ufn_GetMSIntFormTime]
(
@dt DATETIME
)
RETURNS BIGINT
AS
BEGIN
-- Declare the return variable here
DECLARE @dtInt BIGINT
SELECT @dtInt=DATEDIFF(SECOND , '1970-01-01 08:00:00.000' , @