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
- 6532 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
Can you explain different types of joins?
How many types of subqueries are there in sql server?
How to retrieve error messages using mssql_get_last_message()?
What is ms sql server reporting services?
What is the current pricing model of SQL Azure?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Write a SQL queries on Self Join and Inner Join.
Difference between drill down and drill through report.
What is Replication?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain what is lock escalation and what is its purpose?
What is a group function explain with an example?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
How to create a user name in a database?
Can we write a distributed query and get some data which is located on other server and oracle database?
