House of Fusion
Home of the ColdFusion Community

Search nycfug

December 02, 2008

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31       

Search over 2,500 ColdFusion resources here  >>>      
Home /  Groups /  New York ColdFusion Users Group (NYCFUG)

quick SQL server question

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
I need to
R.J.Siegel
12/23/05 02:59 P
Maybe
Cook, Scott
12/23/05 03:10 P

12/23/2005 02:59 PM
Author:
R.J.Siegel

I need to SELECT DISTINCT somedate as fld,    count(somedate) as cnt from #tablename# but I can't get it to ignore the time-part of the date/times.  I tried Dateparts, but got strange results. Is there some function that returns date-only? -- -- Bob/Jules Siegel  Bob.Siegel@verizon.net -- -- ColdFusion / Web Databases / OurSubscribers.com ---

12/23/2005 03:10 PM
Author:
Cook, Scott

Maybe convert(char(11),somedate,109) as fld Select the format you want and replace 109 with that I need to SELECT DISTINCT somedate as fld,    count(somedate) as cnt from #tablename# but I can't get it to ignore the time-part of the date/times.  I tried Dateparts, but got strange results. Is there some function that returns date-only? -- -- Bob/Jules Siegel  Bob.Siegel@verizon.net -- -- ColdFusion / Web Databases / OurSubscribers.com --- ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.csfb.com/legal_terms/disclaimer_external_email.shtml ==============================================================================


<< Previous Thread Today's Threads Next Thread >>

Mailing Lists