HPE Community
Server Management - Systems Insight Manager
1833752 Members
2772 Online
110063 Solutions
New Discussion

Re: Field type have changed in the Database Tables (NOTICES) in HPSIM 4.2

 
Carlos Pascual_1
New Member

‎01-25-2005 01:49 AM

‎01-25-2005 01:49 AM

Field type have changed in the Database Tables (NOTICES) in HPSIM 4.2

HI
In CIM 7 I used a query with tables.field:

notices.Generated = datetime dd/mm/yyyy
notices.fixed = = datetime dd/mm/yyyy

In SIM 4.2

notices.Generated = milisecond from 1970
notices.Cleared = milisecond from 1970

Anyone knows how convert this timestamp in a datetime

Thanks in advance

SALUD
0 Kudos
Reply
1 REPLY 1
David Claypool
Honored Contributor

‎01-25-2005 02:37 AM

‎01-25-2005 02:37 AM

Re: Field type have changed in the Database Tables (NOTICES) in HPSIM 4.2

Do a Google search of "millisecond since 1970" and you will find a number of sources for algorithms that deal with this.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.