In Clearspace we store dates using their millisecond representation rather than as a full fledged date in database tables because we don’t want to have to worry about how each database represents dates, but that means that whenever you’re looking at a Clearspace database table, you see values like this:
instead of something like this:
and then click ‘run’ and voila. You’ve got the date. Have I told you how much I love Firebug?