in ms-access we can use select format(date(),'mmmm')

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

Question Posted / rajiv rohilla

Answer Posted / rajiv rohilla

in ms-access we can use
select format(date(),'mmmm')

Is This Answer Correct ?

37 Yes

28 No

Please Help Members By Posting Answers For Below Questions

Describe how to use linked server?

933

What are the differences between substr and charindex in sql server.

1013

How to copy the tables, schema and views from one sql server to another?

990

What type of Index will get created after executing the above statement?

1045

Why are sql functions used?

1044

How do I shrink an ldf file?

932

What are the rendering extensions of ssrs?

142

What is an indexing technique?

869

Can I run multiple instances of sql server 2000 at the same time on one computer?

1023

What are the advantages of user-defined functions over stored procedures in sql server?

960

Explain acid?

1017

What are recommended options to be used while using db mirroring? : sql server database administration

1070

what is the difference between a primary key and a unique key? : Sql server database administration

946

What is dbcc command in sql server?

1019

Differentiate between a having clause and a where clause.

925