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

What is a collation in ms sql server?

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

Is truncate a dml command?

What is cross join in sql server joins?

Explain the use of containers in ssis?

What is difference between rollback immediate and with no_wait during alter database?

Do you know the cursor optimization tips?

Why should we go for stored procedures? Why not direct queries?

what is the difference between delete,drop and truncate

What is sql server database?

What is user defined datatypes and when you should go for them?

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

For more SQL Server Interview Questions Click Here