時間戳轉(zhuǎn)換

daxuewuhen2014

現(xiàn)在日志里有一些時間都是這樣的
20140302143011
20140302143011
20140302143237  
現(xiàn)在在請把它轉(zhuǎn)換成時間戳

laliheyi

回復(fù) 1# daxuewuhen2014

你想要哪樣的戳呢？
   

這個冬天不冷

1. [root@syh test]# awk '{t=gensub(/(....)(..)(..)(..)(..)(..)/,"\\1 \\2 \\3 \\4 \\5 \\6","g",$0);print t, mktime(t)}'  a
   
2. 2014 03 02 14 30 11 1393741811
   
3. 2014 03 02 14 30 11 1393741811
   
4. 2014 03 02 14 32 37 1393741957
   
5. [root@syh test]# cat a
   
6. 20140302143011
   
7. 20140302143011
   
8. 20140302143237
   
9. [root@syh test]#
   

復(fù)制代碼

yestreenstars

回復(fù) 3# 這個冬天不冷

打那么多點不累嗎？

1. $ awk -vFIELDWIDTHS='4 2 2 2 2 2' '{$1=$1;print mktime($0)}' i
   
2. 1393741811
   
3. 1393741811
   
4. 1393741957

復(fù)制代碼

這個冬天不冷

回復(fù) 4# yestreenstars
.... 累，向星辰大大學(xué)習(xí) :wink:


   

jason680

回復(fù) 3# 這個冬天不冷

other way

# awk '{t=gensub(/(..)/,"\\1 ","g",$1);sub(" ","",t);print $1"=>"mktime(t)","t}' FILE
20140302143011=>1393741811,2014 03 02 14 30 11
20140302143011=>1393741811,2014 03 02 14 30 11
20140302143237=>1393741957,2014 03 02 14 32 37


   

bikkuri

1. [root@hp8 test]#sed -e 's/\(....\)\(..\)\(..\)\(..\)\(..\)\(..\)/\1-\2-\3 \4:\5:\6/' timelist|while read -r line; do date -d "$line" +%s ; done
   
2. 1393741811
   
3. 1393741811
   
4. 1393741957
   
5. [root@hp8 test]#

復(fù)制代碼

這個冬天不冷

回復(fù) 7# bikkuri


    兄弟，敲這么多點不累么，，@yestreenstars

bikkuri

學(xué)習(xí)了！貌似busybox下的awk不支持FIELDWIDTHS。

1. root@dbox:/tmp/test# awk '{t=gensub(/(....)(..)(..)(..)(..)(..)/,"\\1 \\2 \\3 \\4 \\5 \\6","g",$0);print t, mktime(t)}' timelist
   
2. 2014 03 02 14 30 11 1393741811
   
3. 2014 03 02 14 30 11 1393741811
   
4. 2014 03 02 14 32 37 1393741957
   
5. root@dbox:/tmp/test# awk -vFIELDWIDTHS='4 2 2 2 2 2' '{$1=$1;print mktime($0)}' timelist
   
6. -1
   
7. -1
   
8. -1
   
9. root@dbox:/tmp/test# awk '{t=gensub(/(..)/,"\\1 ","g",$1);sub(" ","",t);print $1"=>"mktime(t)","t}' timelist
   
10. 20140302143011=>1393741811,2014 03 02 14 30 11
    
11. 20140302143011=>1393741811,2014 03 02 14 30 11
    
12. 20140302143237=>1393741957,2014 03 02 14 32 37
    
13. root@dbox:/tmp/test#

復(fù)制代碼

kernel69

perl的點也不少

1. perl -MTime::Local -lne '/(....)(..)(..)(..)(..)(..)/;print timelocal($6,$5,$4,$3,$2-1,$1-1900)' t
   
2. 1393741811
   
3. 1393741811
   
4. 1393741957

復(fù)制代碼

回復(fù) 1# daxuewuhen2014