List of distinct dates - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

List of distinct dates

Message

From

19/02/2008 12:48:19

Sergey Berezniker
New York, United States

To

19/02/2008 12:46:41

Einar Kvandahl
Alliance Laundry Systems
Ripon, Wisconsin, United States

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: List of distinct dates

Environment versions

SQL Server:

SQL Server 2005

Miscellaneous

Thread ID:

01293842

Message ID:

01293861

Views:

18

You're welcome.

>Thanks for a very slick solution.
>
>Einar
>
>>

>>SELECT DISTINCT DATEADD(dd,DATEDIFF(dd,0, MyDate),0) FROM mytable
>>

--sb--

Click here to load this message in the networking platform