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
- 6370 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
What is used to replicate sessions between instances in coldfusion clusters?
How do I install only the client tools of sql server 2000?
What information is maintained within the msdb database?
What function does a database engine serve in the sql server?
What is service broker?
what types of replication are supported in sql server? : Sql server database administration
What is difference between commit and rollback when used in transactions?
What are the difficulties faced in cube development? : sql server analysis services, ssas
can a table be moved to different filegroup? : Sql server administration
What are the advantages of having an index on the sql server?
How to apply cascading referential integrity in place of triggers?
What are logical database components? : SQL Server Architecture
Is resultset an interface?
What are the different ways you can create databases in sql server?
How to create a user name in a database?
