Just some of the peculiar ways Dates can be stored
Graphic showing some of the peculiar ways dates can be stored as both numbers and character strings in SQL columns. None of these are recommended and all give rise to SQL smells.
Making Sense of Information Technology
