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 a benefit of using an after insert trigger over using a before insert trigger?
When to use Inner join & when to use subquery?
Explain indexing and what are the advantages of it?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
0 Answers HPCL, Hughes Systique Corporation,
How to trouble shoot if unable to connect SQL Server
Explain raiserror in sql server?
Do you know what is lock escalation?
Explain stored procedure?
Explain DBMS, RDBMS?
What is cursor ? And what is difference between Trigger ?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is user stored procedure & it purpose?