The comparison of date and time in sqlserver can be directly compared, that is to say, the same time of two types can be directly compared.

The period you said is converted to int type, not int type, but long type.

This conversion is not simply to remove the middle non-digits, but to combine with1900-01-01.

00:00:00 millisecond time difference.