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 [...]
Business Achiever Award Nomination
We are proud to announce we have been nominated for the Business Achiever Award!
Read Full Post | Make a Comment ( None so far )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 [...]
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
