Hi ,

I have a question for all , please help me out.

the question is : i have a query in Oracle like this
select count(*), to_char(ISL_FIRST_VISIT, 'Day, mm/dd/yyyy&#39 from ISL_USERS
group by to_char(ISL_FIRST_VISIT, 'Day, mm/dd/yyyy&#39
order by to_char(ISL_FIRST_VISIT, 'Day, mm/dd/yyyy'

i want to convert this into SQLserver but in SQL server equlent function for TO_CHAR is Datename ..when i have given this i am getting error . please give me the tip on this issue .

thanks
shekhar