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
- 6542 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
What will happen if a column containing char type data is changed to the nchar data type?
How to insert multiple rows with a subquery?
What is always encrypted?
role of sql sever 2005 in database rather than any other database
Is truncate autocommit?
How to modify existing triggers using "alter trigger"?
Explain what are the different index configurations a table can have?
What is nonclustered index with included columns ?
Explain the steps needed to create a scheduled job?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What action plan is preferred if sql server is not responding?
Will sql server 2005 allow you to reduce the size of a column?
What is logon trigger?
What is difference between getdate and sysdatetime in sql server 2008?
What is the difference between ‘having’ clause and a ‘where’ clause?
