How to get the number of quarter from given date?

Posted by Lakhangarg on 2/22/2010 | Category: Sql Server Interview questions | Views: 5862

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

There is one method to get the Quarter number from given date:
DECLARE @GivenDate datetime
SET @GivenDate='2010-02-22 23:06:38.300'

SELECT DatePart(Q,GETDATE())
Output: 1

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Name the utility used to add an assembly into the ...

Next > : How to get the year part from the given Date?

Comments or Responses

More Interview Questions by Lakhangarg

How to get the year part from the given Date?
How to get the Day part from the given Date?
How to get the month value/month part from the given Date?
Can we use Oracle Database as source or destination Database in SSIS?
Name of the containers in SSIS?
Can we write Scripting Language like VB Script and JavaScript in SSIS ...
What is SSIS
Can we create DTS Package in DTS package in SQL Server 2005 or higher ...

Latest Interview Questions

Adding year to a date ??
Adding minutes to a date ??
Adding months to a Date in SQL ??
Which namespace provide classes for integration with WPF and Win32?
What is the use of "System.Windows.Markup" namespace in WPF?
How to define a button USING XAML?
What is WPF?
How can you restrict all the textbox's autocomplete to off in a form ?
More ...