Yep depends on the State Laws (unless the Feds come knocking) and for the most part they detail what can be done. In most states a "Search" Warrant can be served anytime, but "Arrest" Warrants can be limited to time of day based on Misdemeanor or felony status of arrestee.
Most states require "Notice" . Drug or weapons notice might be followed by the door flying open. If they are looking for business records, they might even contact your lawyer first and have him there when they wait for you to answer the door.
Officer safety, ability to dispose of the evidence, criminal history of the occupants, etc can all come in to play.
Don't believe what you read from some of the Tin foil hat JBT haters around here. Their idea of due process and contesting a warrant is to die in a blaze of glory, while the constitutional method is to contest it in court. You probably won't die a self-satisfied martyr but your wife, families and dogs will thank you later.