for i in `seq 0 4095`; do
    bound=`printf %03x $i`; 
    query="
      update revision
        set 
          date_offset_bytes=_format_offset(date_offset, date_neg_utc_offset),
          committer_date_offset_bytes=_format_offset(committer_date_offset, committer_date_neg_utc_offset)
        where
          id > '\x${bound}0' 
          and id <= '\x${bound}fffffffffffffffffffffffffffffffffffff' 
          and (
            (date is not null and date_offset_bytes is null)
            or (committer_date is not null and committer_date_offset_bytes is null)
          );
    ";
    echo "updating for revisions starting with ${bound}";
    time psql 'host=db1.internal.staging.swh.network port=5432 user=swh dbname=swh' -c "$query";
done