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

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

Post New Answer

More SQL Server Interview Questions

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  


What is entity data services?

0 Answers  


You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  


What is resource governor?

0 Answers  


How many types of the database links?

0 Answers   MCN Solutions,






How to turn off warning messages during php execution?

0 Answers  


What are the advantages of passing name-value pairs as parameters?

0 Answers  


where can you add custom error messages to sql server? : Sql server administration

0 Answers  


how to know Who Is Blocking Your SQL Server?

4 Answers  


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,


What are logical database components? : SQL Server Architecture

0 Answers  


What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  


Categories