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
- 6493 Views
- I also Faced
- E-Mail Answers
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
Explain index in sql server?
Explain Reporting Life Cycle?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What are cursors stored procedures and triggers?
How to create a scrollable cursor with the scroll option?
What is difference between materialized view and view?
can we have a nested transaction? : Sql server database administration
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to divide query output into multiple groups with the group by clause in ms sql server?
why would you use sql agent? : Sql server database administration
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain where clause?
How to encrypt data between dialogs?
Explain about remote stored procedure?
Which are the third-party tools used in sql server and why would you use them?
