[dbo].[date2secs]

(local) > mdb > Scalar-valued Functions > dbo.date2secs

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@date	datetime	8

SQL Script

SET QUOTED_IDENTIFIER OFF
GO
CREATE FUNCTION dbo.date2secs(@date datetime)returns bigint
as begin
return convert(bigint, datediff(ss, '01-01-1970 00:00:00', @date), 101)
end

GO

Uses