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
- 5326 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 is wide table?
What is a non equi join?
Define a cross join?
Does group by or order by come first?
What are clustered and non-clustered index?
What are scalar functions in sql?
Are resultset updatable?
What is difference between equi join and inner join?
Difference between Sql server reporting services and Crystal reports?
How do you use a subquery to find records that exist in one table and do not exist in another?
Define views.
Differentiate sql server reporting services vs. Crystal reports?
What causes index fragmentation?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What are drillthrough reports?
