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

Answer Posted / brahma prakash

FOR POSTGRES DATABASE
SELECT to_char(NOW(),'month')

Is This Answer Correct ?    15 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a self join? Explain it with an example? : Sql server database administration

651


How can we migrate from SQL server to SQL Azure?

106


What is best institute to Learn DotNET And SQL in chennai?

1897


Explain “row_number()” in sql server with an example?

717


How to get the definition of a trigger back?

728






how many bits ip address consist of? : Sql server database administration

630


Can binary strings be used in arithmetical operations?

680


What are partitioned views?

743


Explain the concepts and capabilities of sql server?

687


Tell me what is sql profiler?

791


What were the latest updates to SQL Azure service?

102


How many types of dimensions are there and what are they? : sql server analysis services, ssas

774


What do you mean by normalisation?

681


Tell me what do you mean by an execution plan? Why is it used? How would you view it?

666


Give an example of why you would want to denormalize a database

709