Interested to Buy Any Domain ? << Click Here >> for more details...
hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000
- 3 Answers
- 6695 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
We can get date, month and year seperately from the
current date like
select DATEPART(d, getdate()) to get current date
select DATEPART(mm, getdate()) to get current month
select DATEPART(yy, getdate()) to get current year
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do I view a trc file?
How do I schedule a sql server profiler trace?
Name some of the open source software that you can use in alternative to SSR?
How can you ensure that the database and sql server based application perform well?
What do you understand by the analysis services in sql server?
List the different normalization forms?
Should you normalize audio?
Explain different backup plans?
What are indexers?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What do you mean by 'normalization'?
Does the unique constraint create an index?
How retrieve field names from the table in SQL through JAVA code?
How you provide security to cube? : sql server analysis services, ssas
