How do we get month name in SQL Server 2000, Oracle, MS Access?
Answers were Sorted based on User's Feedback
Answer / menaka
In Oracle,
SELECT to_char(sysdate,'month') from dual
Is This Answer Correct ? | 50 Yes | 11 No |
Answer / kongu karunakaran
select datename(month,parametername or columnname) from
tablename
Is This Answer Correct ? | 33 Yes | 16 No |
in ms-access we can use
select format(date(),'mmmm')
Is This Answer Correct ? | 37 Yes | 28 No |
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 |
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 |
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 |
Answer / brahma prakash
FOR POSTGRES DATABASE
SELECT to_char(NOW(),'month')
Is This Answer Correct ? | 15 Yes | 14 No |
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 |
What are the advantages of sql stored procedure?
Can we passed multiple recordset(set of records) using a Stored Procedure
What are the various Isolation levels?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What is an example of a foreign key?
What is rolap and its advantage? : sql server analysis services, ssas
How display code or Text of Stored Procedure using Sql query in Sql Server ?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance
Is foreign key a primary key?
what are cursors? : Sql server database administration