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
- 6679 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 window functions in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
Why Master database is required?
Write a query to find 5th highest amount paid from the customer table.
How to implement service broker?
Explain different types of Normalization.
How many full-text indexes can a table have?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the recursive stored procedure in sql server?
on line cluster can we make if yes tell me the procedure
If a stored procedure is taking a table data type, how it looks?
How to create a dml trigger using create trigger statements?
What are triggers in ms sql server?
What is sql server english query?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
