Home -> Mailing Lists -> Oracle-L -> SQL_MONITOR , timestamp value

SQL_MONITOR , timestamp value

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Tue, 31 Mar 2020 20:29:18 +0000
Message-ID: <VI1PR05MB3199D9E95FF4117242A34F60F3C80_at_VI1PR05MB3199.eurprd05.prod.outlook.com> 





Hallo,

in v$sql_monitor output  are timestamp bind values:

Binds
========================================================================
| Name | Position |   Type    |                       Value            |
========================================================================
| :1   |        1 | RAW(32)   | f2341da4276d8046a38288d45167661c       |
| :2   |        2 | TIMESTAMP | 7877031203192A0C1988C0                 |
| :3   |        3 | TIMESTAMP | 7878031E05372E14810600                 |
| :4   |        4 | NUMBER    | 1                                      |
========================================================================

How to convert timestamps to readable format ?

Best Regards,
Petr
--


http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 31 2020 - 22:29:18 CEST












Original text of this message