bigframes.bigquery.date_diff#

bigframes.bigquery.date_diff(end_date: Series | Expression | Literal[Sentinel.ARGUMENT_DEFAULT] | date, start_date: Series | Expression | Literal[Sentinel.ARGUMENT_DEFAULT] | date, granularity: Series | Expression | Literal['YEAR', 'ISOYEAR', 'QUARTER', 'MONTH', 'WEEK', 'ISOWEEK', 'DAY', 'DAYOFWEEK', 'DAYOFYEAR', 'HOUR', 'MINUTE', 'SECOND', 'MILLISECOND', 'MICROSECOND'] | Literal[Sentinel.ARGUMENT_DEFAULT]) → Series | Expression[source]#

Gets the number of unit boundaries between two DATE values (end_date - start_date) at a particular time granularity.