Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
List of distinct dates
Message
From
19/02/2008 12:54:24
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:
01293867
Views:
19
>You do realize that result column is not datetime?
>
>>Thank you Bruce for a slick solution.
>>>
>>>SELECT  DISTINCT CONVERT(CHAR(10), MyDate, 120)
>>>
I do, but I should have emphasised that distinction to Einar. Thanks.
Previous
Reply
Map
View

Click here to load this message in the networking platform