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

Answer Posted / test

select datename(month,getdate())

Is This Answer Correct ?    11 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How dts is used to extract, transform and consolidate data?

591


How to loop through result set objects using odbc_fetch_row()?

464


Does view occupy space?

509


What is the standby server?

512


What is Transparent Data Encryption?

585






How optimize sql query with multiple joins in sql server?

413


What do you understand by the data quality services in sql server?

491


What is a dataset and what are the different types of datasets?

93


Explain the truncate command?

518


Explain some stored procedure creating best practices or guidelines?

513


what are constraints? Explain different types of constraints? : Sql server database administration

496


mention different types of relationships in the dbms?

501


What is the difference between substr and charindex in the sql server?

499


How to change the password of a login name in ms sql server?

556


What are the underflow and overflow behaviors on float literals?

568