Timestamps
I was wondering how everyone else stores dates in their webapplications.
I've always used timestamp(14)'s in my databases. I never have to write code to tell the database when I added a row. There is another problem: Whenever I update the row, the timestamp also updates, something I almost always *don't* want to happen.
I was thinking of instead switching from a timestamp to a number field, and using " table.date = NOW()" in the query. The MySQL docs say that it should resemble the format of the old timestamp. Does this sound like a good strategy?
I've always used timestamp(14)'s in my databases. I never have to write code to tell the database when I added a row. There is another problem: Whenever I update the row, the timestamp also updates, something I almost always *don't* want to happen.
I was thinking of instead switching from a timestamp to a number field, and using " table.date = NOW()" in the query. The MySQL docs say that it should resemble the format of the old timestamp. Does this sound like a good strategy?
