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
- 6433 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
How many levels of sp nesting are possible?
How to use linked server?
How to handle error or exception in sql?
Which data type columns are the best candidates for full-text indexing?
Do you know what are the restrictions that views have to follow?
In what version of sql server were synonyms released?
Mention the differences between substr and charindex in sql server.
What is the difference between dropping a database and taking a database offline?
How to recompile stored procedure at run time?
Explain raiserror in sql server?
Mention the differences between local and global temporary tables.
Are null values the same as that of zero or a blank space?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is isnull() operator?
What is mean by candidate key?
