.Net DateTime fiscal Quarter

Does anyone know how to construct a DateTime in .NET to be 开发者_JAVA百科the first day of the current quarter?

---

public DateTime GetCurrentQuarter(DateTime date)
{
    int startingMonthOfQuarter = (((date.Month - 1) / 3) * 3) + 1;

    return new DateTime(date.Year, startingMonthOfQuarter, 1);
}

---

        var currentTime = DateTime.Now;
        var year = currentTime.Year;
        DateTime[] quarterStarts = {new DateTime(year, 1, 1), new DateTime(year, 4, 1), new DateTime(year, 7, 1), new DateTime(year, 10, 1)};
        var currentStart = quarterStarts.Where(s => s < currentTime).Last();

---

@yogesh is right, here's what I use in a sql sp:

CREATE FUNCTION [dbo].[fn_startOfQtr](@dt DATETIME) 
RETURNS DATETIME AS  
BEGIN 
    declare @ret DATETIME
    declare @qtr int

    set @qtr = ((month(@dt)-1)/3)+1
    set @ret = cast(str(@qtr * 3 - 2) + '/1/' + str(year(@dt)) as DATETIME)
    return @ret
END