Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     What is date-timestamp Format of START_STAMP and END_STAMP in the BOTLOG Table

Read-Only Read-Only Topic
Go
Search
Notify
Tools
What is date-timestamp Format of START_STAMP and END_STAMP in the BOTLOG Table
 Login/Join
 
Gold member
posted
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.


Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster
 
Posts: 64 | Location: Toronto, Ontario | Registered: May 15, 2014Report This Post
Master
posted Hide Post
More detailed explanation of this available in below post from Susannah.

How to Read the ReportCaster Schedule File

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Gold member
posted Hide Post
Unfortunately the link Doesnot Open.
Can you give a piece of code that converts Zulu Timestamp to a readable timestamp?


Webfocus 8105,8808,7703,7611, EXL2K,HTML,PDF,COMT,AHTML Info Assist+ , Reportcaster
 
Posts: 64 | Location: Toronto, Ontario | Registered: May 15, 2014Report This Post
Virtuoso
posted Hide Post
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


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Expert
posted Hide Post
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



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     What is date-timestamp Format of START_STAMP and END_STAMP in the BOTLOG Table

Copyright © 1996-2020 Information Builders