Bash TZ-DATETIME 변환

Bash TZ 날짜시간 DATETIME 변환

1 TZ → DATETIME

DATETIME=`date +%Y-%m-%d\ %H:%M:%S -d "${TZ:0:8} ${TZ:9:8}"`

[root@zetawiki ~]# TZ=20140702T21:17:41Z
[root@zetawiki ~]# echo $TZ
20140702T21:17:41Z
[root@zetawiki ~]# DATETIME=`date +%Y-%m-%d\ %H:%M:%S -d "${TZ:0:8} ${TZ:9:8}"`
[root@zetawiki ~]# echo $DATETIME
2014-07-02 21:17:41

2 DATETIME → TZ

TZ=${DATETIME:0:4}${DATETIME:5:2}${DATETIME:8:2}T${DATETIME:11:8}Z

[root@zetawiki ~]# DATETIME='2014-07-03 11:52:00' 
[root@zetawiki ~]# echo $DATETIME
2014-07-03 11:52:00
[root@zetawiki ~]# TZ=${DATETIME:0:4}${DATETIME:5:2}${DATETIME:8:2}T${DATETIME:11:8}Z
[root@zetawiki ~]# echo $TZ  
20140703T11:52:00Z

3 같이 보기

• MySQL datetime, timestamp 차이
• Unixtime-DATETIME 변환
• ISO 8601