How to compare two dates (excluding time) ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to compare two dates (excluding time) ?

Message

De

13/02/2002 13:02:48

Michael Levy
Cincinnati, Ohio, États-Unis

À

13/02/2002 12:55:34

Marc Levesque
La Prairie, Québec, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: How to compare two dates (excluding time) ?

Divers

Thread ID:

00619595

Message ID:

00619600

Vues:

17

This message has been marked as the solution to the initial question of the thread.

DATEDIFF(day, date_1, date_2) = 0 will be true if the two datetimes have the same date component.

-Mike

Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com

Click here to load this message in the networking platform