In Oracle, SELECT to_char(sysdate,'month') from dual

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

Question Posted / menaka

Answer Posted / menaka

In Oracle,

SELECT to_char(sysdate,'month') from dual

Is This Answer Correct ?

50 Yes

11 No

Please Help Members By Posting Answers For Below Questions

System variable and temporary variables

2295

What is a file group?

1159

What is difference between stored procedure and user defined function?

1162

Explain error handling in ssis?

1066

How do you create a clustered index?

1120

Do you know what is fill factor and pad index?

1040

Which database stores information about replication?

1121

What is the difference between function and stored procedure in sql server?

1144

What is store procedure? How do they work?

1064

What is catalog views?

1115

What is precedence constraint?

1030

How can I tell if sql server is 32 or 64 bit?

1010

What is the temp table?

968

what is datawarehouse?

1147

What are the benefits and tasks of object explorer? : sql server management studio

1247