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:47:53

Einar Kvandahl
Alliance Laundry Systems
Ripon, Wisconsin, United States

To

19/02/2008 12:39:02

Bruce Kuyper
Summit Datanet
Helena, Montana, 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:

01293860

Views:

11

Thank you Bruce for a slick solution.
>

>SELECT  DISTINCT CONVERT(CHAR(10), MyDate, 120)
>

Semper ubi sub ubi.

Click here to load this message in the networking platform