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

Answer Posted / test

select datename(month,getdate())

Is This Answer Correct ?    11 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the properties of sub-query in sql server?

726


What is the difference between resultset and resultsetmetadata?

702


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2030


What are logical database components? : SQL Server Architecture

654


How many servers can we create in a single subscription?

156






What are commonly used odbc functions in php?

719


What is sql server query analyzer?

709


How to insert and update data into a table with "insert" and "update" statements?

699


What is thr feature of change data capture?

671


Do you know what are the properties of the relational tables?

786


Describe in brief authentication modes in sql server.

731


What are statistics?

777


What are Row versions of DataRow?

784


What are the new features of sql server 2008 r2 reporting service?

124


Tell me what is the difference between locking and multi-versioning?

757