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
- 6570 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
What are the types of processing and explain each? : sql server analysis services, ssas
What to perform pattern match with the like operator?
Can we write ddl in trigger?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What are trace flags and mention a few common trace flags used with sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can truncate be rolled back?
Can we call stored procedure in view in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is sql collation?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Why use view instead of a table?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Do you know what is lock escalation?
