Archive for August, 2008

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.

3 comments August 25, 2008

Business Achiever Award Nomination

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

Add comment August 22, 2008

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.

1 comment August 3, 2008

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

Add comment August 3, 2008


Email Subscription

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

Archives

Recent comments

Blogroll

Top Rated

Top Clicks

Category Cloud

Advertising Brisbane SEO clickfind Business Directory ColdFusion Environmental initiatives Google Google Adwords Google Analytics In the media JavaScript JavaScript Form Validation Marketing MS SQL Other Programming Search Engine Optimization & Marketing Yahoo

Tags

alexa alexa ranking analytics anchor text links australia Australian Search Engines bartercard base bbx business directories business directory business directory review cfc clickfind ColdFusion confidence forum gadget Google hash html internet traffic keywords list local search markup MS SQL online marketing pagerank PR Programming RSS search engine search engines security SEO spellcheck spelling stored procedure tool trust tutorial validation website design www.mergermarket.com

Blog Stats

Top Posts

Authors