High Quality Content by WIKIPEDIA articles! "Zero Hour" is the fourth episode from Season 8 of the military science fiction television series Stargate SG-1. It was written by producer Robert C. Cooper and directed by Peter Woeste. Clips of the episode were shown on Late Night with Conan O`Brien before Season 8 began, with Late Night graphic designer Pierre Bernard making a cameo appearance in the episode. The first airing of "Zero Hour" on July 30, 2004 on the American Sci Fi Channel was viewed by 3 million Americans. The episode received mixed reviews.