I wanted take a snapshot of the active/queued jobs at say 8 AM in the morning and want them to be exported to some location.
I have a sample query that pulls out the active jobs
SELECT * FROM domain_job WHERE state = 1
Also the query for queued jobs is
SELECT * FROM domain_job WHERE state = 0
But when the query runs the columns that contain the start time ,end time info are in the format
135892025510000000 (basically eighteen digit numbers with the last seven digits as 0 )
To my knowledge the ctime number is usually 10 digits,so when I take the first 10 digits for conversion (1358920255),I get the output as
Wed, 23 Jan 2013 05:50:55 GMT which im sure is not the output .
How to understand the format or change the format in the sql script or at excel ??
Give this a try :