Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

MySQL Timestamp Confusion More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

death to timestamps (Score:1)

by rjbs (4671) on 2007.04.23 9:50 (#54636) Homepage Journal

Yeah, I've worked with a big pile of MySQL-based software that uses timestamps instead of date times all over the place, and then does crazier things. The first timestamp, for example, is used as a last modification time, except it's displayed to the users as something more like a created/modified-in-certain-way time, meaning that if you modify other fields, you have to modify that one to explicily /not/ change.

Sure, it's a sign of programmer failure, but it's yet another case where MySQL makes easy things easy and horrible things probable.

--
rjbs

Reply to This

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.