converting date and grouping

• orkie

  Valued Member

  Points: 53

  More actions

  January 26, 2005 at 4:23 am

  #183951

  Hello,

  I am using the following query;

  select count(*), convert(varchar,DateTime,101) from divuk group by datetime

  I would like it to count all the DateTime records that are the same and group by them but i get the following output,

  count/datetime

  1 10/10/2004

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  1 01/25/2005

  Can anyone help?

   

  thanks

• orkie

  Valued Member

  Points: 53

  More actions

  January 26, 2005 at 5:31 am

  #539106

  ignore my mistake! 😮

   

  of course it wont work unless i group by the same convert!