Hi

I am trying to create a Webfocus Utilization Report Using BOTLOG table of ReportCaster Metadata,

The Column Start_Stamp has value like '00000000000000000001417602095864'.

Not Sure what this format is and How can i derive the Date-timestamp out of this.

Please Help.

More detailed explanation of this available in below post from Susannah.

How to Read the ReportCaster Schedule File

Thanks,
Ram

Unfortunately the link Doesnot Open.
Can you give a piece of code that converts Zulu Timestamp to a readable timestamp?

It's the number of milliseconds since midnight on January 1st, 1970 in the GMT/UTC time zone.

I haven't found a way to convert that to a local datetime using plain FOCUS code, but I did manage to convert it using the following bit of passthru SQL (Our report caster database lives in an MSSQL database):

SQL SQLMSS PREPARE SQLOUT FOR
SELECT GETDATE() - GETUTCDATE() AS DIFF_UTC, ' ' AS DUMMY;
END

DEFINE FILE SQLOUT
	EPOCH_AT_TZ/HYYMDs = HADD(DIFF_UTC, 'yy', 70, 8, EPOCH_AT_TZ);
END
TABLE FILE SQLOUT
PRINT EPOCH_AT_TZ
BY DUMMY
ON TABLE HOLD AS MAI00010H_TZINFO FORMAT FOCUS INDEX DUMMY
END
-RUN

John Gray wrote an excellent article on adjusting for local time - link - combine that with the article from Susannah and it's easy to build what you need.

Also search on Zulu time from the search button above. There are a whole host of posts on this subject.

Suffice to say that the number is a count of milliseconds since the base date-time.

T