Use the right data types.

Don’t use a datetime data type if the job calls for a date data type.

The extra data in hours / minutes / seconds will cause bugs.

You will also have bugs with time zones.