"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 people. the episode received mixed reviews.