Parade Series - date

unix2linux

已于 2024-09-06 17:50:25 修改

阅读量316

点赞数 4

文章标签：数据库

于 2024-07-11 22:12:24 首次发布

本文链接：https://blog.csdn.net/unix2linux/article/details/140363390

版权

在这里插入图片描述

/home/u01/push>TS=`date "+%s%N"` ; echo $TS
1723280312084135053

/home/u01/push>python
Python 3.10.12 (main, Mar 22 2024, 16:50:05) [GCC 11.4.0] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import time
>>> print(int(round(time.time() * 1000)))
1723280263343
>>> print(int(round(time.time() * 1000000)))
1723280361129967
>>> print(int(round(time.time() * 1000000000)))
1723280410798840064
>>>
/home/u01/push>TS=`date "+%s%N"` ; echo $TS
1723280415817387513

/opt/admin/bin>TS=`date "+%Y-%m-%d %H:%M:%S"` ; echo $TS
2024-08-08 16:01:17
/opt/admin/bin>
/opt/admin/bin>TS=`date "+%s"` ; echo $TS
1723104083
/opt/admin/bin>
/opt/admin/bin>TS=`date "+%s%N"` ; echo $TS
1723104088635482548

/opt/admin/bin>bofTime=`date "+%s"`; sleep 5;eofTime=`date "+%s"`;elapsedTime=$(expr $eofTime - $bofTime )
/opt/admin/bin>echo $bofTime $eofTime $elapsedTime
1723104174 1723104179 5

/opt/admin/bin>date "+%Y%m%d%H%M%S"
20240711221026
/opt/admin/bin>date '+%s'
1720707047

/opt/admin/bin>date -d "-1 day" '+%Y-%m-%d %H:%M:%S'
2024-07-11 09:52:34
/opt/admin/bin>date -d "-1 day" '+%s'
1720662949

/opt/admin/bin>date -d "-7 day" '+%Y-%m-%d %H:%M:%S'
2024-07-05 09:53:14
/opt/admin/bin>date -d "-7 day" '+%s'
1720144546

/opt/admin/bin>date -d "-30 day" '+%Y-%m-%d %H:%M:%S'
2024-06-12 09:53:45
/opt/admin/bin>date -d "-30 day" '+%s'
1718157342

/opt/admin/bin>date -d "-60 day" '+%Y-%m-%d %H:%M:%S'
2024-05-13 09:53:49
/opt/admin/bin>date -d "-60 day" '+%s'
1715565340

/opt/admin/bin>date -d "-90 day" '+%Y-%m-%d %H:%M:%S'
2024-04-13 09:53:54
/opt/admin/bin>date -d "-90 day" '+%s'
1712973335

/opt/admin/bin>date -d "2024-07-13 12:00:00"            "+%Y%m%d%H%M%S"
20240713120000
/opt/admin/bin>date -d "2024-07-13 12:00:00  1 minute " "+%Y%m%d%H%M%S"
20240713120100
/opt/admin/bin>date -d "2024-07-13 12:00:00 30 minute " "+%Y%m%d%H%M%S"
20240713123000
/opt/admin/bin>date -d "2024-07-13 12:00:00 60 minute " "+%Y%m%d%H%M%S"
20240713130000
/opt/admin/facade/3600>

STIME=`echo "${STIME:0:4}-${STIME:4:2}-${STIME:6:2} ${STIME:8:2}:${STIME:10:2}:${STIME:12:2}"`

sudo timedatectl set-timezone Asia/Shanghai
sudo date -s '2024-07-15 08:45:00'

{
  "data": [
    {
      "status": "closed",
      "path": "15.15.90.244",
      "session": "d58646e1",
      "created": "18:29:47",
      "closed": "18:31:13"
    },
    {
      "status": "running",
      "path": "15.15.40.220",
      "session": "3e874731",
      "created": "18:31:30",
      "closed": ""
    }
  ],
  "updated": "2024-08-08 19:02:57",
  "elapsed": "14"
}

running elapsed

TODAY=`date "+%Y-%m-%d"`
createdTS=`date -d "$TODAY $created" "+%s"`
if [ -z "$closed" ]; then
	nowTS=`date "+%s"`
	elapsedTS=$(expr $nowTS - $createdTS)
	elapsedTime=$(expr $elapsedTS)
fi

closed elapsed

TODAY=`date "+%Y-%m-%d"`
createdTS=`date -d "$TODAY $created" "+%s"`
if [ -n "$closed" ]; then
	closedTS=`date -d "$TODAY $closed" "+%s"`
	elapsedTS=$(expr $closedTS - $createdTS)
	elapsedTime=$(expr $elapsedTS)
fi

{
  "data": [
    {
      "status": "closed",
      "elapsed": "86",
      "path": "15.15.90.244",
      "session": "d58646e1",
      "created": "18:29:47",
      "closed": "18:31:13"
    },
    {
      "status": "running",
      "elapsed": "1887",
      "path": "15.15.40.220",
      "session": "3e874731",
      "created": "18:31:30",
      "closed": ""
    }
  ],
  "updated": "2024-08-08 19:02:57",
  "elapsed": "14"
}

Get Timeout from sqlite3 db

#####################################################################
# PLEASE DO NOT EDIT THIS FILE
#####################################################################

LOOP=1

if [ -z "$LOOP" ]; then
    LOOP=3
fi

. $HOME/bin/setenv

#####################################################################

TS=`date "+%s%N"`
TMPSQL="run"$TS".sql"
TMPLST="run"$TS".list"

echo                                                > $TMPSQL
echo .mode csv                                     >> $TMPSQL
echo .output $TMPLST                               >> $TMPSQL
echo SELECT FirstValue FROM data_dictionary WHERE MasterKey=\'TIMEOUT\' AND SlaveKey=\'T1\'\;  >> $TMPSQL
echo .output stdout                                >> $TMPSQL

sqlite3 $NVRSTORE                                   < $TMPSQL
if [ $? -eq 0 ]; then
    cat $TMPLST | sed 's/"//g' | sed 's/\r//g' | awk '{print ""$1""}'
fi

rm -f $TMPSQL
rm -f $TMPLST
#####################################################################

Day Cut Off

YESTODAY=`date -d "-1 day" "+%m%d"` ; echo $YESTODAY
HHMM=`date "+%H%M"` ; echo $HHMM
if [ "$HHMM" == "0000" ]; then
	cp nohup.out nohup.out.$YESTODAY
	> nohup.out
fi

Begin Of Day

YESTODAY=`date -d "-1 day" "+%m%d"` ; echo $YESTODAY
TODAY=`date "+%m%d"` ; echo $TODAY
HH=`date "+%H"` ; echo $HH
if [ "$HH" == "00" ]; then
	cp nohup.out nohup.out.$YESTODAY
	> nohup.out
fi

End Of Day

TODAY=`date "+%m%d"` ; echo $TODAY
TOMORROW=`date -d "1 day" "+%m%d"` ; echo $TOMORROW
HH=`date "+%H"` ; echo $HH
if [ "$HH" == "23" ]; then
	cp nohup.out nohup.out.$TODAY
	> nohup.out
fi

today & yestoday

/opt/admin>date -d "-1 day" '+%Y%m%d'
20240905
/opt/admin>date "+%Y%m%d"
20240906

/opt/admin>date "+%Y:%m:%d"
2024:09:06
/opt/admin>date -d "-1 day" '+%Y:%m:%d'
2024:09:05

convert text to unix timestamp

/opt/admin>text="2024-09-06 17:17:41" ; echo $text;
2024-09-06 17:17:41

/opt/admin>date -d "$text" "+%s"
1725614261

convert unix timestamp to date

/opt/admin>date -d "@1725614261" "+%Y-%m-%d %H:%M:%S"
2024-09-06 17:17:41

calculate time interval

/opt/admin>bofDate="2024-09-06 17:17:41"; echo $bofDate
2024-09-06 17:17:41
/opt/admin>eofDate="2024-09-06 18:17:41"; echo $eofDate
2024-09-06 18:00:00

/opt/admin>com-date-to-long "$bofDate" ; com-date-to-long "$eofDate" ;
1725614261
1725617861

/opt/admin/mqtt>delta=$(expr 1725616800 - 1725614261); echo $delta s eplapsed
3600 s eplapsed