select datename(month,parametername or columnname) from tablename

How do we get month name in SQL Server 2000, Oracle, MS Access?

Question Posted / kongu karunakaran

Answer Posted / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Is This Answer Correct ?

33 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1033

What are the general features of sql server management studio? : sql server management studio

1077

Write a SQL query in order to merge two different columns into single column?

1036

What is exporting utility?

1022

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

946

How you provide security to cube? : sql server analysis services, ssas

965

What is a db view?

900

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1143

What is the meaning of resultset type_scroll_insensitive?

956

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1044

What is the use of tempdb? What values does it hold?

1072

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1148

What is store procedure? When do you use?

937

What is a field name?

967

How many types of subqueries are there in sql server?

992