Posted by sdowney717@msn.com on 03/11/06 15:27

SQLQuery = "SELECT distinct CONVERT(char,circdate,1) from circdata"

I think I solved it
any one see a problem with this?
thanks
how does the '1' parameter affect the output as I know there are
several choices

• Next in forum: Re: Execution Plan Hinting
• Prev in forum: looking to collect distinct date part out of datetime field
• Thread view: Re: looking to collect distinct date part out of datetime field

[Reply to this message]