MS SQL Date Time to Epoch

I know it’s been a while for you programmers out there, but here is an MS SQL function that converts Date Time to Epoch.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER FUNCTION [dbo].[fn_dateTimeToEpoch] (
 @dateTime DATETIME
)
RETURNS BIGINT
AS
BEGIN

 DECLARE @epochDay BIGINT
 DECLARE @epochSecond INT

 – epoch ‘01-01-1900 00:00:00′
 – one day 86400 seconds

 SET @epochDay = DATEDIFF( day, ‘01-01-1900 00:00:00′, @dateTime )
 – get the remainder
 SET @epochSecond = DATEDIFF( second, ‘01-01-1900 00:00:00′, DATEADD( day, -@epochDay, @dateTime ) )

 – convert to seconds
 RETURN ( @epochDay * 86400 ) + @epochSecond

END

 

Leave a message if you want the Epoch to Date Time function.

Business Achiever Award Nomination

We are proud to announce we have been nominated for the Business Achiever Award!

Prevent Online Fraud Website

Inline with our direction to support small businesses, we are sponsoring a new website called preventonlinefraud.org which will publish information on how you as a business can help prevent online fraud.

This direction will also eventually lead to another website which will allow any online user to verify an Australian business in several ways, aiding with the prevention of online fraud.

Environmental initiatives

Keeping in line with our new direction for clickfind #2 we are collecting information about environmental initiatives on this site that we can promote on clickfind. If you know of any that should be on this list please feel free to post a comment or email us.

The Equator Principles
www.equator-principles.com