Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Which of the following datepart argument is used to get the MINUTE value from datetime using DATENAME() function in SQL server?
on 11/14/2013 | Category:
Sql Server Interview questions
| Views: 5589 |
Select from following answers:
DATENAME ( datepart , date ) function returns a character string that represents the specified datepart of the specified date.
Datepart abbreviations are as follows:
SELECT DATENAME ( n, GETDATE()) MinuteValue
SELECT DATENAME ( mm, GETDATE()) MonthName
SELECT DATENAME ( m, GETDATE()) MonthName
SELECT DATENAME ( mcs, GETDATE()) MicroSeconds
Show Correct Answer
Many Interviews |
< Previous :
How to generate grand total for the total column a ...
Next > :
What is the output of select ISNULL(10, getdate()) ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What is the output of select ISNULL(10, getdate()) as 'IsNullWithD ...
What is the output of select COALESCE(10, getdate()) as 'COALESCE& ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which word is missing from the following statement to create a stored ...
Which of the following is the standard four-part naming convention whe ...
What is missing from the T-SQL statement below for creating and using ...
One table has historical transactions details. The table only has 10 c ...
Which of the following would be a correct way to call the stored proce ...
Latest Interview Questions
How does Garbage Collector works?
What is the maximum capacity of a DataTable in ADO.NET?
What is the use of Html.ValidationSummary helper method in ASP.NET MVC ...
How to write dashed attributes of html (5) element using ASP.NET MVC H ...
What is the use of ViewStart in ASP.NET MVC?
What different types of Scaffold templates are there in ASP.NET MVC?
you need to identify Is Always a number Is Always greater than a 65, ...
What is a Linked Server?