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
Answer Posted / aravazhi
select month(getdate()) Curr_Mon,Year(getdate())
Curr_Year,day(getdate()) as Curr_day
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to write an inner join with the where clause in ms sql server?
What are different types of table joins?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
Explain how you can configure a running aggregate in SSRS?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Explain different types of Normalization.
Do you know sql server 2008 backup compression?
Explain datetime2 data type in sal server 2008?
what information is maintained within the msdb database? : Sql server administration
What is the function of sql server agent windows service?
What is data mart? : sql server analysis services, ssas
ow to bring suspect mode datbase online from scratch
Define self join?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration