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
- 6561 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
Write a sql query to get zero records from a table having n number of records?
What are the benefits of normalization?
What type of Index will get created after executing the above statement?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is exclusive locks?
How can we determine what objects a user-defined function depends upon?
What are acid properties of transaction?
Which is faster statement or preparedstatement?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What you can do to delete a table without the delete trigger firing?
Where cross join is used?
What is the difference between update lock and exclusive lock?
Tell me what is the order in which the sql query is executed?
what is the primary use of the model database? : Sql server administration
Do you know what is sql injection?
