メインコンテンツまでスキップ
バージョン: 4.x

WEEKS_DIFF

デスクリプション​

2つの日付または時刻の値の間の完全な週数（7日単位）を計算します。

Syntax​

WEEKS_DIFF(<end_date>, <start_date>)

必須パラメータ​

パラメータ名Data タイプデスクリプション
end_dateDATE, DATETIME後の日付または日時
start_dateDATE, DATETIME前の日付または日時

例​

  1. 2020-12-25と2020-10-25の間は何週間ありますか

    select weeks_diff('2020-12-25','2020-10-25');
    +----------------------------------------------------------+
    | weeks_diff('2020-12-25 00:00:00', '2020-10-25 00:00:00') |
    +----------------------------------------------------------+
    |                                                        8 |
    +----------------------------------------------------------+

  2. 2020-12-25 10:10:02と2020-10-25 12:10:02の間には何週間ありますか

    select weeks_diff('2020-12-25 10:10:02','2020-10-25 12:10:02');
    +--------------------------------------------------------------------------------------------------------+
    | weeks_diff(cast('2020-12-25 10:10:02' as DATETIMEV2(0)), cast('2020-10-25 12:10:02' as DATETIMEV2(0))) |
    +--------------------------------------------------------------------------------------------------------+
    |                                                                                                      8 |
    +--------------------------------------------------------------------------------------------------------+

  3. 2020-12-25 10:10:02と2020-10-25の間には何週間ありますか

    select weeks_diff('2020-12-25 10:10:02','2020-10-25');
    +----------------------------------------------------------------------------------------+
    | weeks_diff(cast('2020-12-25 10:10:02' as DATETIMEV2(0)), cast('2020-10-25' as DATEV2)) |
    +----------------------------------------------------------------------------------------+
    |                                                                                      8 |
    +----------------------------------------------------------------------------------------+