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 derfloh 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
Joined
Jun 15, 2004
Messages
2
Location
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 Question
HP Insight 7 SP2 - Reports
Replies
0
Views
172
Carl44
Carl44
nnatt76
  • Locked
  • Question Question
Reports
Replies
1
Views
177
staps
staps
damianpadden
  • Locked
  • Question Question
cim reporting
Replies
1
Views
145
msingle
msingle
msingle
  • Locked
  • Question Question
modify SQL statements used on reports page
Replies
0
Views
113
msingle
msingle

Part and Inventory Search

Sponsor

Back
Top