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

Answer Posted / sairam

select datename(mm,getdate())

Is This Answer Correct ?    173 Yes 30 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can binary strings be used in arithmetical operations?

681


What is SQL Azure Data sync?

115


What are the different authentication modes in sql server?

803


List the data types available in mssql?

706


Explain an incremental backup?

749






Do you know what are the properties of the relational tables?

786


What is the filtered index?

772


Will count(column) include columns with null values in its count?

842


Write a SQL command to insert and update only a particular field?

798


How to list all user defined functions in the current database?

694


What are rest-style architecture's?

163


What is bulkcopy in sql?

731


Explain the steps needed to create a scheduled job?

674


Can you explain what are commit and rollback in sql?

682


What is the purpose of sql profiler in sql server?

699