Archive for January, 2009

Warning – Google May Harm Your Computer

Posted on January 31st, 2009 |


Careful, according to Google, the site may be harmful to your computer.

2 Comments » | Categories: Uncategorized

Covert UNIX Epoch dates in Microsoft Excel – Including Timezone Examples

Posted on January 22nd, 2009 |

There are many sites out there that will give you a full description of what the UNIX Epoch standard date system is, why it is used, and a thorough understanding of why that’s important to you. You also probably don’t have time for a history/computer science course when all you want to do is convert that time stamp into something that looks nice for your boss in Excel. In that case, here you go:

All examples shown assume that the UNIX time stamp is in column A.

GMT – Greenwich Mean Time – This is the standard example you see across the Internet

EST – Eastern Standard Time (GMT – 5:00)

CST – Central Standard Time (GMT – 6:00)

MST – Mountain Standard Time (GMT – 7:00)

PST – Pacific Standard Time (GMT – 8:00)

Now set your column format to a Date field to your liking. I use the 3/14/01 13:30 format so I can include the easily sortable military time format.

16 Comments » | Categories: Uncategorized

Don’t set your WordPress address URL to something other than the folder WordPress is installed

Posted on January 22nd, 2009 |

I’ve recently redirected my home page of to using Apache’s mod_rewrite functions. This way users coming to the main site are transparently redirected to the blog yet the old Google indexed URLs that are referencing the blog subfolder still work. I wanted my sitemap which is built by a WordPress plugin to reference the URLs without the blog subdirectory since it’s cleaner. Instead of manually changing the xml output (which would have taken all of 10 seconds) I decided to change the WordPress address setting in the control panel. My thought was that it would then just reference instead of while still redirecting traffic to the proper path due to the mod_rewrite rule in place.

After doing this the website could still be viewed properly and all the links worked but when trying to sign into wp-admin the system would just bring me back to the login page without any error messages. To fix the issue I had to log into my virtual host site and manually change the siteurl field in the options MySQL table back to

Lesson learned. Read about what the functions do before making assumptions.

1 Comment » | Categories: Uncategorized