There are many time and date formats in sql server with different ranges, accuracies, storage sizes and user defined fractional second precisions.

Below is a short overview.

....

continue reading