Mercoledì, 05 Febbraio 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

 

Letto 27138 volte
Pubblicato in SQL
Altro in questa categoria: « Convert a Midas datetime to SQL Find all the dependencies for an Entity/column »
Torna in alto