Data ModelingFunction ListweekOn this pageweekExtracts the week number from a date value. Syntax week(<date>) ParameterTypeDescriptiondateDateThe date value to process. Return values Integer Usage Extracts the week number from the order creation date. week(orders.created_at) Related functions year weekday month day quarter