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
- 6551 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
We can get date, month and year seperately from the
current date like
select DATEPART(d, getdate()) to get current date
select DATEPART(mm, getdate()) to get current month
select DATEPART(yy, getdate()) to get current year
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the types of indexes?
What are security principals used in sql server 2005?
Explain about the command-line tool SQLCMD?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Do you know what guidelines should be followed to help minimize deadlocks?
how can you attach more than 20 ldf files in sql server
How to generate create procedure script on an existing stored procedure?
Difference between LEN() and DATALENGTH() in sql server ?
How to encrypt Strored Procedure in SQL SERVER?
What are the different types of stored procedures?
Where is my database stored on the hard disk in ms sql server?
How to check if stored procedure is running in sql server?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is store procedure? How do they work? When do you use?
Explain the xml support sql server extends?
