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.

can an order by clause be used in a creation of a view?

0 Answers  

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

How do indexes help, types?

0 Answers  

How to list all schemas in a database?

0 Answers  

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

SQL Server Architecture ?

0 Answers   IBM, Sapient,

What is “asynchronous” communication in sql server service broker?

0 Answers  

Is t sql the same as sql server?

0 Answers  

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

What is a unique index?

0 Answers  

What is cursors? And what are the different types of cursor?

0 Answers  

What are the advantages of mirroring?

0 Answers