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' from ISL_USERS
group by to_char(ISL_FIRST_VISIT, 'Day, mm/dd/yyyy'
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