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
- 6681 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 alternate key, candidate key and composite key in sql server?
Explain how dts is used to extract, transform and consolidate data?
Describe the functionalities that views support.
difference between Clustered index and non clustered index ?
Where can you find the error log information? : sql server database administration
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Define Business Edition in SQL Azure?
What is create statement?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
List the various tools available for performance tuning?
Explain stored procedure?
What are the steps to follow to configure SQL*Net?
Why should you use or avoid select * statements?
Mention a few common trace flags used with sql server?
