Showing a Column as a UNIX Timestamp in MySQL

While MySQL has quite an assortment of date and time formats which it supports, I usually find it most convenient to store timestamps as an INT and just put the UNIX seconds since the epoch value in there. … A drawback is that sometimes when I’m working with the database by hand it’s annoying to see the timestamps as big numbers – sometimes it would be very helpful to see them as dates and times. … The “FROM_UNIXTIME()” function will interpret a numeric column’s value as a UNIX seconds-from-the-epoch value and show it as a date and timestamp. Using it I can easily do things like: SELECT URL, FROM_UNIXTIME(Timestamp) FROM AccessLog; and see it as: +—————————+————————–+ | URL | FROM_UNIXTIME(timestamp) | +—————————+————————–+ | explore/users/94 | 2008-10-05 22:49:39 | +—————————+————————–+ rather than +—————————+————+ | URL | timestamp | +—————————+————+ | explore/users/94 | 1223261379 | +—————————+————+

More

MacOS X DVDs – Versions and Saving a Little Money on Them

The family pack is licensed for use for up to five machines in one household, and lists for $199, a pretty good deal for staying legal at less than the cost of two single user licenses. … At the time I wrote this, they were charging $26 less than list for the single user edition and $44.51 less than list for the family pack , both with free shipping. … You should be forewarned that, in my experience, the restore DVD that comes with a computer will only work with that computer or class of computers. … Amazon also has a pretty good deal on Leopard Server: $104.51 off the 10 user version (normal list price $499) and $168.46 off the unlimited user version (normal list price $999).

More

Working Through a Catalyst View Rendering Problem

I’ve been adding some belated email notifications to UVFood and in the process I ran into a frustrating problem: it wasn’t working at all. … Views are for rendering pages, but Catalyst::View::Email takes already-rendered text and then emails it somewhere. … I’ve written templates for the messages I need to send using HTML::Mason, so I need to render these templates before I can send a message.

…The fix is to fully qualify the view name, ie: my $v = $c->view(‘UVFoodApp::View::Mason’); Now I’m getting the correct component.

More

Keeping Your Warcraft Addons Up To Date

wowmatrix.jpg While I’m on the subject of World of Warcraft, I want to take a moment to mention the software I use to keep the add-ons I use up to date. … The set I use started out as “GrimPack” from “GrimPickle” – it’s a good set of add-ons which have been tested with one another (and in some cases fixed to work better together). You can download it from http://www.grimpickle.com If you install it, the first time you start World of Warcraft afterwards, your screen will probably be a complete mess. … Once you’ve got a good set of add-ons working for you, you can use WoWMatrix to keep them up to date.

More

World of Warcraft: Wrath of the Lich King Is Out on November 13th

"World of Warcraft: Wrath of the Lich King Expansion Pack" Blizzard has announced that the new expansion pack, Wrath of the Lich King, will be released on November 13th, 2008. … The “collector’s edition” includes a 208 page book, a key to unlock a special baby frost wyrm pet, a DVD with developer interviews, the official soundtrack CD, a mousepad and two starter decks of cards including two cards only available in the collector’s edition. … You can order the "World of Warcraft: Wrath of the Lich King Expansion Pack" for $3 under the normal price, or "World of Warcraft: Wrath of the Lich King Collector’s Edition" for full price, with a limit of one per household. … Wrath of the Lich King requires that you already have a copy of the original "World of Warcraft" and the first expansion, "World Of Warcraft Expansion: Burning Crusade" .

More