A database is being designed to store data about sales. One of the attributes is for tracking when the sale occurred. The time of sale needs to be tracked to include date and time both $--$ but the accuracy needed is at least till seconds as required by the credit card company.

What would be the best data type for time of sale attribute?

datetime

need to store day, month, year, hours, minutes, seconds separately as integers

insufficient information to make determination

smalldatetime