oracle 显示时间戳,强制oracle sql developer显示时间戳

作者：weixin_40725706 | 2024-05-23 02:28:09

踩

resource activation timeout

我终于找到了要做的事，

我刚刚从更改了我的SQL查询

SELECT ALARMID,ALARMNAME,ALERTKEY,SITENAME,FIRSTOCCURRENCE,LASTOCCURRENCE,CLEARTIME,NODE,MANAGER

FROM ACROSSFM1.REPORTER_STATUS

WHERE ALARMID IN ('301','21801','22202','29240','14001','29201','199087342',

'199087337','198099803','199083022','199066019','199083023',

'198094419','198094422','S1 Link is Broken',

'CELL LOGICAL CHANNEL AVAILABILITY SUPERVISION','UtranCell_NbapMessageFailure',

'UtranCell_ServiceUnavailable','UtranCell_RBSLocalCellNotAdded',

'Heartbeat Failure','ResourceConfigurationFailure','ServiceUnavailable',

'Resource Activation Timeout','ResourceAllocationFailure','S1apLinkDown')

AND Type = 2

AND LASTOCCURRENCE > (SYSDATE-(1/24));

到

SELECT ALARMID,ALERTKEY,ALARMNAME,SITENAME,CEIL(((FIRSTOCCURRENCE)- (TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))) * 86400),CEIL(((LASTOCCURRENCE)- (TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))) * 86400),CEIL(((CLEARTIME)- (TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))) * 86400),NODE,MANAGER

FROM ACROSSFM1.REPORTER_STATUS

WHERE ALARMID IN ('301','21801','22202','29240','14001','29201','199087342','199087337','198099803','199083022','199066019','199083023','198094419','198094422','S1 Link is Broken','CELL LOGICAL CHANNEL AVAILABILITY SUPERVISION','UtranCell_NbapMessageFailure','UtranCell_ServiceUnavailable','UtranCell_RBSLocalCellNotAdded','Heartbeat Failure','ResourceConfigurationFailure','ServiceUnavailable','Resource Activation Timeout','ResourceAllocationFailure','S1apLinkDown','21807','21825')

AND Type = 2

AND LASTOCCURRENCE > (SYSDATE-(1/24));

我会说

CEIL(((FIRSTOCCURRENCE)- (TO_DATE('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'))) * 86400)

完成了这项工作。

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/weixin_40725706/article/detail/610954