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
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 is collation sensitivity? Explain different types.
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is the difference between push and pull subscription? : sql server replication
What is the difference between writing data to mirrored drives versus raid5 drives
Why and when do stored procedure recompile?
How is SQL Azure different than SQL server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
How to get the definition of a stored procedure back?
What is the use of “join” in sql server?
What is simple indexing method?
What is meant by indexing?
What are wait types?
What is deploy, process and build? : sql server analysis services, ssas
How to find Duplicate Records In table?