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
- 6535 Views
- I also Faced
- E-Mail Answers
Answer Posted / dharmendra k. dixit
We can do that by writing our query in this way..
Select datename(dd, getdate()) for Date
Select datename(mm, getdate()) for Month
Select datename(yy, getdate()) for Year
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is SQL Azure Fabric?
How do you use a subquery to find records that exist in one table and do not exist in another?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is acid mean in sql server?
What does truncate do?
Explain the truncate command? : SQL Server Architecture
What is a join in sql?
Is sql server is free?
Explain what are commit and rollback in sql?
What is ms sql server reporting services?
What are trace flags?
What is the difference between a primary key and a unique key? Are they the same?
What are the default system databases in sql server 2000?
Describe in brief system database.
How to retrieve error messages using odbc_errormsg()?
