Comparison of two dates and selection of the second in a day or more?

H

H

heavybrain2019-11-13 10:40:01

SQL Server

heavybrain, 2019-11-13 10:40:01

Comparison of two dates and selection of the second in a day or more?

It is necessary to compare 2 dates, and so that the second date starts exactly in a day or more than the first one, how to write it in where? just > this is not correct because then the next day is taken into account ..

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Konstantin Tsvetkov, 2019-11-13
@heavybrain

DateField2 >= DATEADD( hh, 24, DateField1 )

Similar questions

B

Boris the Animal2016-07-17 21:44:15

Is it efficient to query to get the first few records from the database using JOIN? 2Reply

O

one__for__one2018-12-27 10:20:59

Why do you need a logical database name in MS SQL Server? 1Reply

R

Romario212018-12-28 13:07:51

MS SQL timeout on UPDATE? 1Reply

K

Kcid132014-07-13 10:18:10

How to properly connect a DB in ASP.NET MVC 4? 2Reply

K

KJIayD2016-08-05 12:48:42

Backup MS SQL 2014 Express and PowerShell? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question