Very Computer

I need to return each unique or DISTINCT day that occurs
in a field (theTime) in a table (theTable).

Actually, I'll be asking for each DISTINCT day less than
some instance (but that's not an issue).

field (theTime) is of type datetime and typically has one
record inserted into it each second of the day...

--This is close, but it returns the day of the week
select distinct day(theTime) from theTable

ie:  6 and 7 for Saturday and Sunday

I want the actual date

ie:
3/2/2003
3/3/2003

Thanks in advance,
Ben

SELECT DISTINCT CAST(CONVERT(VARCHAR,crdate,112) AS DATETIME)
 FROM sysobjects

--
David Portas
------------
Please reply only to the newsgroup
--

Quote:> Hi,

> I need to return each unique or DISTINCT day that occurs
> in a field (theTime) in a table (theTable).

> Actually, I'll be asking for each DISTINCT day less than
> some instance (but that's not an issue).

> field (theTime) is of type datetime and typically has one
> record inserted into it each second of the day...

> --This is close, but it returns the day of the week
> select distinct day(theTime) from theTable

> ie:  6 and 7 for Saturday and Sunday

> I want the actual date

> ie:
> 3/2/2003
> 3/3/2003

> Thanks in advance,
> Ben

Quote:>-----Original Message-----
>Hi,

>I need to return each unique or DISTINCT day that occurs
>in a field (theTime) in a table (theTable).

>Actually, I'll be asking for each DISTINCT day less than
>some instance (but that's not an issue).

>field (theTime) is of type datetime and typically has one
>record inserted into it each second of the day...

>--This is close, but it returns the day of the week
>select distinct day(theTime) from theTable

>ie:  6 and 7 for Saturday and Sunday

>I want the actual date

>ie:
>3/2/2003
>3/3/2003

>Thanks in advance,
>Ben
>.