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
- 6364 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
Explain the truncate command? : SQL Server Architecture
what is an extended stored procedure? : Sql server database administration
Explain primary key, foreign key and unique key?
After removing a table from database, what other related objects have to be dropped explicitly?
Does sql server 2000 clustering support load balancing?
What are the types of lock supported by ?
What functions can a view be used to performed?
In which tcp/ip port does sql server run? Can it be changed?
Can you explain powershell included in sql server 2008?
What is importing utility?
Can we insert data if clustered index is disabled?
User wants only to display only pdf as export option in report manager. How to achieve this?
Do you know what are the steps to process a single select statement?
What is difference between inner join and join?
what are the types of indexes? : Sql server database administration
