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
- 6689 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
Write SQL queries on Self Join and Inner Join.
Tell me can we use custom code in ssrs?
How global temporary tables are represented and its scope?
List some advantages and disadvantages of stored procedure?
Who developed sql server?
What is a transact-sql statement?
What does indexation mean?
Differentiate between a having clause and a where clause.
What do you understand by integration services in sql server?
How do you send email on SQL Server?
What is stretch database in sql server?
What is Lock table in SQL?
How to create a dml trigger using create trigger statements?
How to create an identity column?
Where is my database stored on the hard disk in ms sql server?
