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!

VLDB - Dates

Status
Not open for further replies.
ekramer18

ekramer18

Programmer
May 25, 2007
8
US
I'm extracting information from the VLDB, and am curious about the way dates are stored. For example, a row in the job_record table has a value of 948605476 in the jobstarttime column.

From the ARCserve reports, it seems that this value resolves to 2008-04-10 18:17.

If someone could tell me how that numeric value resolves to that timestamp, I would be eternally grateful. Thanks!
 
Sort by date Sort by votes
not sure what algorithm or logic is used to resolve..
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

viberts
  • Locked
  • Question
Migrate central VLDB database to Central sql database
Replies
4
Views
66
viberts
viberts
culdenickel
  • Locked
  • Question
VLDB to SQL transfer - Multiple backup servers on one SQL database
Replies
1
Views
39
davidmichel
davidmichel
davidmichel
  • Locked
  • Helpful tip
VLDB Update
Replies
0
Views
30
davidmichel
davidmichel
whobodies
  • Locked
  • Question
fist backup and a corrupted VLDB?
Replies
1
Views
38
haral
haral
worldmac1
  • Locked
  • Question
Dates cached in the "Session ID" of the Deferred Eject area
Replies
0
Views
23
worldmac1
worldmac1

Part and Inventory Search

Sponsor

Back
Top