人事资料修复

来源:互联网 发布:朋友圈小视频制作软件 编辑:程序博客网 时间:2024/03/29 03:22

昨天人事主机的控制器时间给初始化了,给调到1970年,时间又与标准时间相差6小时30分左右,日期好改一些,但时间就不好办了,幸而有网上的朋友帮忙,有如下代码要吧改过来了,原来资料

"08686:20050117:050740:4:02:1:051:00000000"
"06665:20050117:051919:4:02:1:051:00000000"
"07440:20050117:051923:4:02:3:051:00000000"
"10724:20050117:051959:4:02:3:051:00000000"
"05545:20050117:052000:4:01:4:051:00000000"
"08301:20050117:052007:4:02:3:051:00000000"

修改code:

修改后为:

"08686:20050117:113740:4:02:1:051:00000000"
"06665:20050117:114919:4:02:1:051:00000000"
"07440:20050117:114923:4:02:3:051:00000000"
"10724:20050117:114959:4:02:3:051:00000000"
"05545:20050117:115000:4:01:4:051:00000000"
"08301:20050117:115007:4:02:3:051:00000000"

waker:

tzs=$TZ
export TZ=UTC0
awk  'BEGIN{FS=":";OFS=":"}{a=$3;
a=gensub(/(..)(..)(..)/, "1970 01 01 1 2 3 0", "g",a);
a=mktime(a)+mktime("1970 01 01 06 30 00 0");
print $1,$2,strftime("%H%M%S", a),$4,$5,$6,$7,$8;}'  yourfile
export TZ=$tzs


tianci3982730:

代码:
awk -F[:] '{"date -d " """$2" "substr($3,1,2)":"substr($3,3,2)":"substr($3,5,2)" $(date +%Z) +$(echo $((06*3600+30*60)))second " """ " +%Y%m%d:%H%M%S"|getline b ;print $1":"b":"$4":"$5":"$6":"$7":"$8 }' file

linux下测试通过
你也可直接把$(echo $((06*3600+30*60)))写成23400了速度更快
也可直接把$(date +%Z)写成你的时区了如CST速度更快了
当然也可把这些放在BEGIN里了。
如下
代码:
awk -F[:] '{"date -d " """$2" "substr($3,1,2)":"substr($3,3,2)":"substr($3,5,2)" CST +23400second " """ " +%Y%m%d:%H%M%S"|getline b ;print $1":"b":"$4":"$5":"$6":"$7":"$8 }' file

shaoping0330:

#!/bin/bash
# 0 successd
# 2 the file is not exist
# 1 Usage is error
# 3 bak file is exist
if [ ! -f $1 ];then
echo "${1} : The file is not exist ,please try later!"
exit 2
fi

if [ $# -ne 1 ];then
echo "USAGE: $0 file"
exit 1
fi

if [ -f ${1}.bak ];then
echo "${1}.bak : the bak file is exist,please delete at first"
exit 3
fi

line=$(wc -l ${1}|awk '{print $1}')

i=1
while [ $i -lt $line ];do
my_time=$(awk -F":" '{print $3}' ${1} |sed -n "$i"'p')
my_hour=${my_time:0:2}
my_minute=${my_time:2:2}
my_second=${my_time:4:2}

# my_second=$((my_second+00))
my_minute=$((my_minute+30))
my_hour=$((my_hour+06))

# if [[ my_second -gt 60 ]];then
# my_second=$((my_second-60))
# my_minute=$((my_minute+1))
# fi
# if [[ my_second -lt 10 ]];then
# my_second=0${my_second}
# fi

if [[ my_minute -gt 60 ]];then
my_minute=$((my_minute-60))
my_hour=$((my_hour+1))
fi

if [[ my_minute -lt 10 ]];then
my_minute=0${my_minute}
fi

my_time=${my_hour}${my_minute}${my_second}
sed -n "${i} s/:[0-9]{6}:/:${my_time}:/p" ${1} >> ${1}.bak

((i++))
done

阅读(1469) | 评论(0) | 转发(0) |
0

上一篇:我的adsl-server被攻击了

下一篇:心情不好

相关热门文章
  • 加强合同、劳动人事、财务、商...
  • 维护表空间和数据文件...
  • linux系统意外重启后无法进入...
  • 国有产权(股权)交易...
  • protobuf 资料汇总
  • 承接自动化测试培训、外包、实...
  • Solaris PowerTOP 1.0 发布
  • For STKMonitor
  • busybox的httpd使用CGI脚本(Bu...
  • 项目小体会
  • IBM DS3400 盘阵怎么查看是单...
  • 启动auditd时,报错如下,怎么...
  • CGSL系统中root密码正确,但无...
  • 在CGSL系统中,如何为不同的用...
  • CGSL系统如何设置交换分区的大...
给主人留下些什么吧!~~
原创粉丝点击