Project

General

Profile

Feature #80

增加绝对秒时间转换和删除历史库exe程序

Added by yufeng wu about 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
05/11/2019
Due date:
05/11/2019
% Done:

0%

Estimated time:
Defect version:

Description

convSecWithDate
1)不加参数,获取显示当前时间自1970年1月1日开始计算的绝对秒,按回车键退出显示
举例:convSecWithDate
显示:1557565818
2)加1个参数(绝对秒),获取显示参数(绝对秒)对应的时间(年月日时分秒),按回车键退出显示
举例:convSecWithDate 1554969605
显示20190411 16:00:05
3)加2个参数,第1个参数为月数(例如N个月),第2个参数为DEL(3个字符)。对QTISCS系统的所有历史数据库的TB3001_ALMH表,删除N个月以前的数据,执行1次自动退出。
N为0时,默认删除24个月以前数据
举例:删除1个月前所有数据convSecWithDate 1 DEL
SendOneCmdStringToSrv: DELETE from SEDATUM.TB3001_ALMH WHERE F3001_DATE< 1554969604
使用建议:删历史库功能可以配置到操作系统的计划任务中,每个月的11日执行一次。

History

#1

Updated by yufeng wu about 5 years ago

  • Status changed from New to Resolved

已完成测试
SVN已提交

#2

Updated by xiangyang li about 5 years ago

  • Target version set to 2.2
#3

Updated by xiangyang li almost 5 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF