SQL Internal Datetime:

datetime

Date and time data from January 1, 1753 through December 31, 9999, to an accuracy of one three-hundredth of a second (equivalent to 3.33 milliseconds or 0.00333 seconds). Values are rounded to increments of .000, .003, or .007 seconds, as shown in the table.

Example:

Create Table Test(ColA datetime,COlB datetime)

GO

Set DateFormat mdy

GO

Insert Test values('4/21/2003 3:32:53PM','4/21/2003 15:32:53')

GO

Select * from Test Where COlA=ColB

GO

Drop Table Test

GO