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

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / honeysukumar

11 Answers
54649 Views
I also Faced
E-Mail Answers

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