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

Question Posted / honeysukumar

Answers were Sorted based on User's Feedback

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

Answer / anil sharma

SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007

Is This Answer Correct ?

5 Yes

10 No

More SQL Server Interview Questions

Why do we need normalization?

What are the different ways you can create databases in sql server?

What is sparse columns of sql server 2008?

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

what is the primary use of the model database? : Sql server administration

Introduction of rollup clause using sum and group by clause?

Explain the different index configurations a table can have?

Why variables called the most powerful component of ssis?

How to list all objects in a given schema?

Does index speed up select statements?

How do you persist objects, permissions in tempdb

How to see existing views in ms sql server?

For more SQL Server Interview Questions Click Here