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
- 5873 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
List few advantages of stored procedure.
Does sql server 2016 have ssms?
What you can do to delete a table without the delete trigger firing?
Can you name a few encryption mechanisms in sql server?
What is subquery in sql?
What is difference between views and tables?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to display a past time in days, hours and minutes?
What is tempdb database? : SQL Server Architecture
Define union, union all, minus, intersect?
how can you check the level of fragmentation on a table? : Sql server administration
Explain the purpose of indexes?
What is report snapshot in ssrs?
What extended events?
How do I uninstall sql server 2014?
