Project a Custom Fiscal Date Part

To project a custom fiscal date part, pass custom fiscal date parts to the EXTRACT() function.
SELECT EXTRACT(FISCAL_YEAR FROM CloseDate) AS CloseDate_Fiscal_Year, EXTRACT(FISCAL_QUARTER FROM CloseDate) AS CloseDate_Fiscal_Quarter, EXTRACT(FISCAL_MONTH FROM CloseDate) AS CloseDate_Fiscal_Month, EXTRACT(FISCAL_WEEK FROM CloseDate) AS CloseDate_Fiscal_Week
FROM "OpportunityFiscalEMTimezoned"
LIMIT 10;
CloseDate_Fiscal_Year CloseDate_Fiscal_Quarter CloseDate_Fiscal_Month CloseDate_Fiscal_Week
2015 4 11 49
2015 4 11 49
2015 4 12 49
2015 4 12 53
2015 4 12 54
2016 1 1 5
2016 1 2 9
2016 1 2 9
2016 1 3 13
2016 1 3 13