[20241125]建立完善zzdate脚本.txt

--//增加%s.%N显示。

# cat /usr/local/bin/zzdate
#! /bin/bash
#date +"trunc(sysdate)+%H/24+%M/1440+%S/86400 == %Y/%m/%d %T == \"timestamp'%Y-%m-%d %T'\""
oflag=${1:-0}
if [ "$oflag" == "0" ]
then
/bin/date +"trunc(sysdate)+%H/24+%M/1440+%S/86400 %s.%N"
else
/bin/date +"trunc(sysdate)+%H/24+%M/1440+%S/86400 == %Y/%m/%d %T === %Y-%m-%d %T == \"timestamp'%Y-%m-%d %T'\" == %s.%N"
fi

--//测试：
$ zzdate
trunc(sysdate)+15/24+45/1440+00/86400 1732520700.291926268

$ zzdate 1
trunc(sysdate)+15/24+45/1440+02/86400 == 2024/11/25 15:45:02 === 2024-11-25 15:45:02 == "timestamp'2024-11-25 15:45:02'" == 1732520702.582339402

ITPub博客

[20241125]建立完善zzdate脚本.txt

最新文章