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 is the syntax for encrypting a column in SQL Server?
How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)
What is a trigger and its types?
Where are sql server user names and passwords stored in sql server?
What is the significance of null value and why should we avoid permitting null values?
Explain user defined views?
What is meant by referential integrity?
What are the types of database schema? : sql server analysis services, ssas
Tell me what is difference between view and materialized view?
Define right outer join?
What is the default order of an order by clause?
what is curser.