Date Functions in SOQL

This table lists all the date functions supported by SOQL.

Date Function	Description	Examples
CALENDAR_MONTH()	Returns a number representing the calendar month of a date field.	1 for January 12 for December
CALENDAR_QUARTER()	Returns a number representing the calendar quarter of a date field.	1 for January 1 through March 31 2 for April 1 through June 30 3 for July 1 through September 30 4 for October 1 through December 31
CALENDAR_YEAR()	Returns a number representing the calendar year of a date field.	2009
DAY_IN_MONTH()	Returns a number representing the day in the month of a date field.	20 for February 20
DAY_IN_WEEK()	Returns a number representing the day of the week for a date field.	1 for Sunday 7 for Saturday
DAY_IN_YEAR()	Returns a number representing the day in the year for a date field.	32 for February 1
DAY_ONLY()	Returns a date representing the day portion of adateTime field.	2009-09-22 for September 22, 2009 You can only useDAY_ONLY() with dateTime fields.
FISCAL_MONTH()	Returns a number representing the fiscal month of a date field. This differs from CALENDAR_MONTH() if your organization uses a fiscal year that does not match the Gregorian calendar. This function is not supported if your organization has custom fiscal years enabled. See "About Fiscal Years" in the Salesforce Help.	If your fiscal year starts in March: 1 for March 12 for February See “Set the Fiscal Year” in theSalesforce online help.
FISCAL_QUARTER()	Returns a number representing the fiscal quarter of a date field. This differs from CALENDAR_QUARTER() if your organization uses a fiscal year that does not match the Gregorian calendar. This function is not supported if your organization has custom fiscal years enabled. See "About Fiscal Years" in the Salesforce Help.	If your fiscal year starts in July: 1 for July 15 4 for June 6
FISCAL_YEAR()	Returns a number representing the fiscal year of a date field. This differs from CALENDAR_YEAR() if your organization uses a fiscal year that does not match the Gregorian calendar. This function is not supported if your organization has custom fiscal years enabled. See "About Fiscal Years" in the Salesforce Help.	2009
HOUR_IN_DAY()	Returns a number representing the hour in the day for a dateTime field.	18 for a time of 18:23:10 You can only useHOUR_IN_DAY() withdateTime fields.
WEEK_IN_MONTH()	Returns a number representing the week in the month for a date field.	2 for April 10 The first week is from the first through the seventh day of the month.
WEEK_IN_YEAR()	Returns a number representing the week in the year for a date field.	1 for January 3 The first week is from January 1 through January 7.

參考網址: https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm

SOQL : https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm