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

How do you rename a table in sql server?

956

What are the different types of collation sensitivity?

1065

How to create new databases with "create database" statements?

969

List the types of recovery model available in sql server?

884

What are policy management terms?

945

Can sql servers linked to other servers like oracle?

906

How to get @@error and @@rowcount at the same time?

994

Do you know nested transaction?

912

Describe the left outer join & right outer join. : sql server database administration

962

Explain differentiate between a having clause and a where clause?

858

What is the difference between grant and with grant while giving permissions to the user?

910

Can we add our custom code in ssis?

948

Why it is recommended to avoid referencing a floating point column in the where clause?

930

what is a join? : Sql server database administration

1147

How do I find sql server instance name?

923