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
- 6371 Views
- I also Faced
- E-Mail Answers
Answer Posted / aravazhi
select month(getdate()) Curr_Mon,Year(getdate())
Curr_Year,day(getdate()) as Curr_day
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain about link server in sql server?
Explain syntax for viewing, dropping and disabling triggers?
What is data source in connection string?
Tell me what is difference between clustered and non clustered index?
What are the steps to follow to configure SQL*Net?
What the different topologies in which replication can be configured?
Data table as parameter in sql server?
Explain sub-query?
What is candidate key with example?
Detail about query optimizer?
How can you check the version of sql server?
In how many ways you can invoke ssrs reports?
Explain the dbcc pintable command when would you use it?
Explain Geography datatype in SQL Server
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
