CREATE TABLE INVOICE_LINEITEM
Come on, it's August and the app's still working just fine. What could possibly go wrong?
Well, it is a CHAR. So technically they can have some kind of mapping...Or maybe its a Boolean. As in 'Y', it is a month of the year, or 'N' - there is no 'March' this year.:)
What if the person was trying to save space?What if the person was using hexadecimal for month?I have to admit; I have never executed such a design in the database.However, I have used the convention for labeling tape sent to offsite storage.For example: 5A22prod – August 22, 2005.
Y2K - nothing!I worked on an accounting system with a single digit for the year.
"Well, it is a CHAR. So technically they can have some kind of mapping..."This is why this posting is called "The Little Things That Snowball"
So does J map to January, June or July? Actually, that's a foolish question, because *obviously* J will map to October. Huh?
If the app work for "M"ay, it works!!! woohoo!
Post a Comment