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 list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

What is standby servers? Explain types of standby servers.

0 Answers  

Do you know what is a linked server in sql server?

0 Answers  

What are different types of schemas?

0 Answers  

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,

What do you mean by recursive stored procedure?

0 Answers  

Explain what are the authentication modes in sql server?

0 Answers  

What are the types of indexing?

0 Answers  

How to create a local temporary stored procedure?

0 Answers