What is the use of DATEPART function in SQL?

Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 3107

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

datepart(parameter,date) will extract the date part according to the parameter passed. The parameters can be yy for year, mm for month or dd for date.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What is the use of DataSet?

Next > : What is the use of DATEDIFF function in SQL?

Comments or Responses

More Interview Questions by Abhisek

What is the use of DATEDIFF function in SQL?
What is the work of a constructor?
Why HashTable is used?
What is the base class for all .NET classes?
What is an Assembly in .NET?
What do you mean by properties in C#?
Which method is used to delete a file in VB.NET?
To reverse a string which function is used in VB.NET?

Latest Interview Questions

Can you compare two SQL fields with datatype "text" by using ...
what is web part?and type
what is MOSS ?
What are ways to create input forms for workflow ?
What are the types of input forms that can be created for a workflow ?
What is Authentication and Authorization.
what is Ajax?
what is PrePageExecute() event
More ...