Steve Jimmo


Blogs

What is Deferred Name Resolution?

By

One interesting concept in SQL Server is Deferred Name Resolution. This is something many...

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...

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