Steve Jimmo

All authors

All authors

Blogs

SQL Server Time Bombs

By

Common Reasons for Emergency SQL calls If you are a production DBA (or Accidental...

Book Review: A Radical Enterprise

By

I grabbed this book over the 2024 holiday season as it was on sale...

Advice I Like: Investing and Growing Rich

By

Investing small amounts of money over a long time works miracles, but no one...

Read the latest Blogs

Forums

Dateadd with a numeric value

By MMartin1

Comments posted to this topic are about the item Dateadd with a numeric value

A Poor Data Model

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Poor Data Model

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

By Abhinay Malipeddi

Comments posted to this topic are about the item Determining Whether Home Addresses Fall...

Visit the forum

Question of the Day

Dateadd with a numeric value

What is returned from the following query ? 

declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000'

select  dateadd(hour, 3.0/2, @currentDateTime);

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy