Archives
-
Removing time from SQL datetime
How many times do you have a data point in your application that is a date but not a datetime? For example: birthdate, receiptdate, licensedate, etc. Things can get really weird when doing date math if these “dates” have times on them – for example: 2.33333 years instead of 2.32. We have even seen some strange things happen with timezones - 8/2/1955 00:00 becomes 8/2/1955 01:00 (still puzzled by this one although I have seen it a few times).