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
- 6497 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 please differentiate between a primary key and a unique key?
how you can get the list of largest tables in a database? : Sql server administration
Why do you want to join software field as you have done your BE in Electronics?
Explain iaas, paas and saas?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
What is dknf in normalization form?
What is the parse query button used for?
What is the maximum size of sql server database?
What are extended events in sql server?
What is GUID in sql server?
In which format does an image save in SQL Server database ?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is a transactions?
What are the disadvantages of primary key and foreign key in SQL?
How to list all user names in a database?
