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

Answer Posted / menaka

In Oracle,

SELECT to_char(sysdate,'month') from dual

Is This Answer Correct ?    50 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many replicas are maintained for each SQL Azure database?

138


What is a trace frag? Where do we use it?

832


How can you find out how many rows returned in a cursor?

754


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1650


How do you identify a foreign key?

776






What is ssl in sql server?

747


Define Joins?

779


What are various aggregate functions that are available?

691


What gets stored inside msdb database?

939


How to list all dsn entries on your local machine using odbc_data_source()?

752


What are the new features in sql server 2016?

706


Which language rdl files made of?

114


How would you go about developing a ssrs report?

135


what stored procedure would you use to view lock information? : Sql server administration

743


What is the native system stored procedure to execute a command against all databases?

716