Toxic Byte

I’ve used regex in postgres a lot, but I’ve got a mysql database with a lot of fields that need updating. They’re in the form of “http://url/?page=keyword” and I want to change that to “http://url/page/keyword/”. So I experiment, but yield no results, in fact errors:

SELECT *
FROM `domain`
WHERE redir REGEX `^http`

Continue Reading »

So, I’ve got this cron job running to log the results of the uptime command every 5 or 10 minutes. Well, it does a timestamp and then adds in the three load values in a tab separated format. Then I can load this into excel for pretty graphs and stuff and see why over night jobs slowed down at certain points.

It is the loading into Excel point where I come a cropper. After all, windows and unix timestamps differ wildly. Although luckily for us not is a cryptic way. So that leaves two options. Store the values in the csv file as a windows value, or simple apply the following formula:

=(A1 / 86400) + 25569

And here this post comes to a sudden end…

Technorati Tags: cron, unix, windows, timestamp, excel