Everything You Ever Wanted to Know About Converting Dates
November 30, 2005 Bruce Guetzkow
The code for this article is available for download.
Although the date data type field has been around for several years now, many of us still have dates stored in our database as numeric or alpha fields. We’ve all used various ways to convert those dates to other formats so they are more human-readable or to comply with client or vendor needs: data structures, move left and move right, the infamous multiplication with truncation trick. While we may not use the date data type in the database, we can still use the date data type to simplify converting dates.