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

Answers were Sorted based on User's Feedback



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

Answer / sairam

select datename(mm,getdate())

Is This Answer Correct ?    173 Yes 30 No

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

Answer / menaka

In Oracle,

SELECT to_char(sysdate,'month') from dual

Is This Answer Correct ?    50 Yes 11 No

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

Answer / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Is This Answer Correct ?    33 Yes 16 No

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

Answer / rajiv rohilla

in ms-access we can use
select format(date(),'mmmm')

Is This Answer Correct ?    37 Yes 28 No

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

Answer / marco birchler

In Oracle make the first letter capital if you wish the
output names also capitalised. "Month" instead of "month"

Is This Answer Correct ?    13 Yes 8 No

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

Answer / test

select datename(month,getdate())

Is This Answer Correct ?    11 Yes 6 No

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

Answer / foram

select month(getdate())
select month(dateparametername) from tablename
---here u will get number of month
or

select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month

Is This Answer Correct ?    7 Yes 5 No

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

Answer / kathiravan jayachandran

In Oracle

select to_char(sysdate, 'dd/mm/yyy')as year from dual


EG:-

select ed.emp_date_of_birth,ed.first_name,ed.last_name
from emp_details ed where
to_char(ed.emp_date_of_birth,'mm')=to_char(sysdate,'mm')

Is This Answer Correct ?    7 Yes 5 No

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

Answer / brahma prakash

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

Is This Answer Correct ?    15 Yes 14 No

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

Answer / aanshi

For oracle, OLD and NEW tables.
For sql server, Inserted & Deleted.
These two tables are also called as magic table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the advantages of sql stored procedure?

0 Answers  


Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  


What are the various Isolation levels?

2 Answers   HP,


What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

0 Answers   Genpact,


If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,






What is an example of a foreign key?

0 Answers  


What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  


How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,


After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,


Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  


Is foreign key a primary key?

0 Answers  


what are cursors? : Sql server database administration

0 Answers  


Categories