Answer / sairam

select datename(mm,getdate())

Answer / menaka

In Oracle,

SELECT to_char(sysdate,'month') from dual

Answer / kongu karunakaran

select datename(month,parametername or columnname) from
tablename

Answer / rajiv rohilla

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

Answer / marco birchler

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

Answer / test

select datename(month,getdate())

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

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')

Answer / brahma prakash

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

Answer / aanshi

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

How to see existing views in ms sql server?

0 Answers  

What are the differences between left join and inner join in sql server?

0 Answers  

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

Explain the benefits of user-defined functions?

0 Answers  

What are the five characteristics of good data?

0 Answers  

What stored procedure can you use to display the current processes?

0 Answers  

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

0 Answers  

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

create index a on employee(dno) In this,which index was created?

2 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

What is log shipping?

0 Answers