This post is more than 5 years old
1 Message
0
1801
July 28th, 2011 09:00
What is f_starttime f_endtime in DATAMINE.BACKUPJOB
I'm trying to query the failed job details using the DATAMINE.BACKUPJOB table. The columns F_STARTTIME,F_ENDTIME are stored in number format and we need this to be in date. How to convert this number to date?
select
f_id,f_module,f_starttime,f_endtime from DATAMINE.BACKUPJOB where f_status='failed' and rownum<=2
F_ID F_MODULE F_STARTTIME F_ENDTIME
38 networker 1267484404 1267486801
273 networker 1267480800 1267487914
No Events found!
ElvinKan
59 Posts
0
July 28th, 2011 09:00
please also be aware that querying the datamine directly is not supported and any poorly structured SQL queries *could* affect the DPA Server's performance. The recommended route of getting data from the datamine is using the DPA GUI and the Report Editor.
Also be aware that after each upgrade of DPA, you will have to revise/check your SQL as the schemas/fields may have changed.
And further to that, the datamine database in future versions (starting from DPA 6.0) will be locked down and this SQL query will not be possible - so if you're doing this for an extra-ordinary reason (eg. under Support's direction for troubleshooting purposes), I strongly recommend that you do not go down this direction as it will only be a temporary route.
Just a heads-up!
Karleke
11 Posts
0
July 28th, 2011 09:00
Hi,
those are the number of seconds from a specific date (usually 1/1/1970 on Unix-platforms). The format is known as "epoch".
You can convert them to a human-readable date and time on http://www.epochconverter.com/ . You can also find information there how to convert them automatically in a bunch of other languages and applications (ie excel, ...).
Regards,
Karl.