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