UNIX日期:如何周数转换为日期范围内(周一至周日)?(UNIX date: How to conv

2019-07-23 03:28发布

我从巨大的日志文件中提取一周号码列表,他们使用的语法提取:

$ date --date="Wed Mar 20 10:19:56 2012" +%W;
12

我想创建一个简单的bash功能,可以将这些周数转换为日期范围。 我想功能应该接受2个参数:$数量和$的一年,例如:

$ week() { ......... }
$ number=12; year=2012
$ week $number $year
"Mon Mar 19 2012" - "Sun Mar 25 2012"

Answer 1:

随着GNU date

$ cat weekof.sh
function weekof()
{
    local week=$1 year=$2
    local week_num_of_Jan_1 week_day_of_Jan_1
    local first_Mon
    local date_fmt="+%a %b %d %Y"
    local mon sun

    week_num_of_Jan_1=$(date -d $year-01-01 +%W)
    week_day_of_Jan_1=$(date -d $year-01-01 +%u)

    if ((week_num_of_Jan_1)); then
        first_Mon=$year-01-01
    else
        first_Mon=$year-01-$((01 + (7 - week_day_of_Jan_1 + 1) ))
    fi

    mon=$(date -d "$first_Mon +$((week - 1)) week" "$date_fmt")
    sun=$(date -d "$first_Mon +$((week - 1)) week + 6 day" "$date_fmt")
    echo "\"$mon\" - \"$sun\""
}

weekof $1 $2
$ bash weekof.sh 12 2012
"Mon Mar 19 2012" - "Sun Mar 25 2012"
$ bash weekof.sh 1 2018
"Mon Jan 01 2018" - "Sun Jan 07 2018"
$


Answer 2:

星期一是一周的第一天, ISO周数 :

function week2date () {
  local year=$1
  local week=$2
  local dayofweek=$3
  date -d "$year-01-01 +$(( $week * 7 + 1 - $(date -d "$year-01-04" +%w ) - 3 )) days -2 days + $dayofweek days" +"%Y-%m-%d"
}

week2date 2017 35 1
week2date 2017 35 7

输出:

2017-08-28
2017-09-03


Answer 3:

如果一个星期的开始是星期天,您可以使用此版本weekof的:

function weekof()
{
    local week=$1 year=$2
    local week_num_of_Jan_1 week_day_of_Jan_1
    local first_Sun
    local date_fmt="+%Y-%m-%d"
    local sun sat

    week_num_of_Jan_1=$(date -d $year-01-01 +%U)
    week_day_of_Jan_1=$(date -d $year-01-01 +%u)

    if ((week_num_of_Jan_1)); then
        first_Sun=$year-01-01
    else
        first_Sun=$year-01-$((01 + (7 - week_day_of_Jan_1) ))
    fi

    sun=$(date -d "$first_Sun +$((week - 1)) week" "$date_fmt")
    sat=$(date -d "$first_Sun +$((week - 1)) week + 6 day" "$date_fmt")
    echo "$sun $sat"
}


Answer 4:

如果有人需要它:我发现了一个更短的方式(不知道是否容易):

function weekof() {
        local year=$2
        local week=`echo $1 | sed 's/^0*//'` # Fixes random bug
        local dateFormat="+%a %b %d %Y"
        # Offset is the day of week, so we can calculate back to monday
        local offset="`date -d "$year/01/01 +$((week - 1)) week" "+%u"`"
        echo -n "`date -d "$year/01/01 +$((week - 1)) week +$((1 - $offset)) day" "$dateFormat"`" # Monday
        echo -n " - "
        echo "`date -d "$year/01/01 +$((week - 1)) week +$((7 - $offset)) day" "$dateFormat"`" # Sunday    }

我把一年的第一天,去ñ周着在正确的地方一周。 然后,我把我平日去后退/前进到达周一和周日。



文章来源: UNIX date: How to convert week number to a date range (Mon-Sun)?