DateTimeTicks SQL Function

The DateTimeTicks() function takes zero (0) argument and returns number of ticks which are number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001 (0:00:00 UTC on January 1, 0001, in the Gregorian calendar). A single tick represents one hundred nanoseconds or one ten-millionth of a second. There are 10,000 ticks in a millisecond, or 10 million ticks in a second.

It's Syntax is simple DateTimeTicks()

		/* Following will output long numeric value */ 
SELECT DateTimeTicks();

Many programs uses it to be precise for datetime value or as primary key.