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 the difference between a local and a global temporary table?

616


What is a synonym for manipulation?

541


What is co-related sub query?

558


What are the types of normalization?

545


What is dynamic cursor in SQL SERVER?

559






Why does sql studio use a single registered database repository? : sql server management studio

521


How will you decide the active and passive nodes?

637


Find nth lowest salary or get nth lowest salary?

587


What is a schema in ms sql server 2005?

559


What is ssl in sql server?

544


Explain the etl (extraction, transformation, and loading)?

555


What are drillthrough reports?

102


How to change a login name in ms sql server?

556


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1497


List types of tables in SQL Azure?

102