Top
image credit: Freepik

Confused About Database Dates? Many Are

Across database structures, dates are ubiquitous: sales date; order date; shipment date; receipt date; created date; last updated date. You might think that with such an abundant presence, dates would be well understood. Sadly, dates hide in the shadows—and many are confused over how dates work. People run a query, get a result, and seem to expect that what one sees, is what one gets. If they see a two-digit year, they believe that is exactly how the data is stored. Similarly, if they see a four-digit year they believe what is kept internally matches that. Often folks have requested database changes to alter how a date is stored. One has such a control over stored formatting of a date only if a date is NOT stored as a date.

Read More on Database Trends and Applications