Wednesday, 05 February 2014 10:58

Convert a real datetime to Midas datetime

Share this post

Submit to Facebook Submit to Google Bookmarks Submit to Twitter

This Scalar-valued function return a Midas datetime from a real datetime. In midas, the date are the number of day since 1971-12-31.

ALTER FUNCTION [dbo].[udf_DateSqlToMidas]
(
	@Date		datetime
)
RETURNS int
AS
BEGIN

RETURN datediff(day, '1971-12-31', @Date)

END

 

Read 27211 times
Published in SQL
More in this category: « Convert a Midas datetime to SQL Find all the dependencies for an Entity/column »
back to top