UNIX timestamp functions implemented in MS SQL Server (including build and format, and MySQL compatible) _mssql

Directly on the code:

CREATE function Unix_timestamp (@ctimestamp datetime) RETURNS integer 
as
BEGIN/
 * FUNCTION body *
 / Declare @return integer
 SELECT @return = DATEDIFF (second,{d ' 1970-01-01 '}, @ctimestamp) return
 @return
end


CREATE FUNCTION from_unixtime (@ts integer) RETURNS datetime 
As
BEGIN/
 * Function body *
 /DECLARE @return datetime
 Select @return = DATEADD (Second, @ts, {d ' 1970- 01-01 '}) return
 @return
end

Usage

Similar to the one under MySQL:

SELECT dbo. Unix_timestamp (' 2013-1-1 ')
select Dbo.from_unixtime (2145000000)