How do we get month name in SQL Server 2000, Oracle, MS Access?
- 11 Answers
- 52266 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do I find my localdb version?
What are the basic features of a trigger in ms sql server?
Please explain go command in sql server?
How to perform key word search in tables?
What is a unique index?
What is @@rowcount in sql?
Give the query of getting last two records from the table in SQL SERVER?
What are advantages of ssrs or why we should use ssrs?
When does a workload on SQL Azure get throttled?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How can you hide the sql server instances?
What is an identity?
What is sql server profiler?
Define Wed Edition in SQL Azure?
How many columns can we include on clustered index ?
