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
- 5872 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
We can do that by writing our query in this way..
Select datename(dd, getdate()) for Date
Select datename(mm, getdate()) for Month
Select datename(yy, getdate()) for Year
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to get all stored procedures in sql server?
How to move database physical files in ms sql server?
How to include text values in sql statements?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to send a ssrs report from ssis?
How many types of functions are there in sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is the difference in accessing db between sql server vs sql azure?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
How to skip remaining statements in a loop block using continue statements?
Name some of the open source software that you can use in alternative to SSR?
Tell about MOM Tool(Microsoft Operator Manager)?
What is the difference between mysql and sql server?
How to find the service pack installed? : sql server database administration
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
