SQL Tips #12 - Making a Default Date Rounded to an Hour

A neat trick for column defaults - how to generate a default date value rounded to the hour.

The Query

(dateadd(day,(7),dateadd(hour,datediff(hour,(0),getutcdate())+(1),(0))))

Disclaimer

These queries are provided as a guide, and are by no means perfect. I didn't write all of these - many are collated from MSDN documentation and community sources over the years.

Tags