Most major land border crossing between the United States and Canada are open 24 hours a day, 7 days a week, 365 days a year. If they weren't, that would cause major economic disruption. Some smaller crossings in rural areas have more limited hours. Of course, they may only have one officer working if you show up at 3AM.