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 is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  


When to use Inner join & when to use subquery?

0 Answers   IBM,


Explain indexing and what are the advantages of it?

0 Answers  


Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,


How to trouble shoot if unable to connect SQL Server

0 Answers  


Explain raiserror in sql server?

0 Answers  


Do you know what is lock escalation?

0 Answers  


Explain stored procedure?

0 Answers  


Explain DBMS, RDBMS?

6 Answers  


What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,


How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  


What is user stored procedure & it purpose?

4 Answers   Wipro,


Categories