CREATE FUNCTION dbo.ToDateTime2 ( @Ticks bigint ) RETURNS datetime2 AS BEGIN DECLARE @DateTime datetime2 = '00010101'; SET @DateTime = DATEADD( DAY, @Ticks / 864000000000, @DateTime ); SET @DateTime = DATEADD( SECOND, ( @Ticks % 864000000000) / 10000000, @DateTime ); RETURN DATEADD( NANOSECOND, ( @Ticks % 10000000 ) * 100, @DateTime ); END
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter