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

Answer Posted / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Is This Answer Correct ?    33 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do you know sql server 2008 introduces automatic auditing?

684


How can you ensure that the database and sql server based application perform well?

793


Can you please explain the difference between function and stored procedure?

748


What happens if you insert a duplicate key for the primary key column in ms sql server?

725


How to enter comments in transact-sql statements?

713






What is the contrast between sql and mysql?

787


Explain system views?

790


Who developed sql server?

690


You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

134


What are the difficulties faced in cube development? : sql server analysis services, ssas

797


What are different types of raid configurations? : SQL Server Architecture

730


Why should one not prefix user stored procedures with ‘sp_’?

807


What are the purposes and advantages stored procedure?

683


How to create a login account in ms sql server to access the database engine using "create login" statements?

735


What is encryption key?

98