FOR POSTGRES DATABASE SELECT to

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

Question Posted / brahma prakash

Answer Posted / brahma prakash

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

Is This Answer Correct ?

15 Yes

14 No

Please Help Members By Posting Answers For Below Questions

What do you know about system database? : SQL Server Architecture

929

How to grant a permission in ms sql server using "grant execute" statements?

1025

How can I get data from a database on another server?

933

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2705

What are exact numeric data types in ms sql server?

989

if no size is defined while creating the database, what size will the database have? : Sql server administration

933

What is a view and what are its advantages?

1053

What is an index. What are the types?

1011

Do you know what are various aggregate functions that are available?

1016

Define a cross join?

953

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1067

What are the different kinds of ssrs reports?

206

How can you check the level of fragmentation on a table?

986

Differentiate sql server reporting services vs. Crystal reports?

187

explain databases and sql server databases architecture? : Sql server database administration

909