Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report dates

Status
Not open for further replies.
kathik

kathik

Technical User
Jun 15, 2004
2
US
I need to know how to interpret the dateTime columns in the Insight_v1_0 tables. For instance, the discovered field of the devices table has data that looks like 1082663222617. Does anyone know how to convert to a readable date?
 
Sort by date Sort by votes
In case anyone else needs this information it is the number of nanoseconds past 1/1/1970.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Carl44
  • Locked
  • Question
HP Insight 7 SP2 - Reports
Replies
0
Views
39
Carl44
Carl44
nnatt76
  • Locked
  • Question
Reports
Replies
1
Views
30
staps
staps
damianpadden
  • Locked
  • Question
cim reporting
Replies
1
Views
30
msingle
msingle
msingle
  • Locked
  • Question
modify SQL statements used on reports page
Replies
0
Views
25
msingle
msingle

Part and Inventory Search

Sponsor

Back
Top