Just the date of a datetime - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Just the date of a datetime

Message

From

01/02/2008 10:44:40

Sergey Berezniker
New York, United States

To

31/01/2008 15:25:22

Einar Kvandahl
Alliance Laundry Systems
Ripon, Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Just the date of a datetime

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01287635

Message ID:

01288124

Views:

14

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

Shorter one

IF DATEDIFF(Day, @Date1, @Date2) = 0 BEGIN
...

>Thanks Sergey. I think I will stick to my current code because I find it easier to read.
>
>

--sb--

Click here to load this message in the networking platform