- 论坛徽章:
- 145
|
本帖最后由 jason680 于 2014-10-30 10:34 编辑
回复 3# youcaihuazi
1. debug by yourself
2. you can change +0 to +8,-8,... for the right answer what you want
Note: all reply DIDNOT modify your system time
$ cat FILE
ID03440321|0|10000|20141023020934
$ awk 'BEGIN{FS=OFS="|"}{d=gensub(/(....)(..)(..)(..)(..)(..)/,"\\1-\\2-\\3 \\4:\\5:\\6","",$4);cmd="date -d \""d" +0\" \"+%Y%m%d%H%M%S\"";cmd | getline D;print "debug: "d"=>"D;$4=D;print}' FILE
debug: 2014-10-23 02:09:34=>20141023100934
ID03440321|0|10000|20141023100934
|
|