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     Packed Numbers and Time Conversions

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Packed Numbers and Time Conversions
 Login/Join
 
MadamZuZu
Gold member
posted
Hello,

i'm very new here, and was wondering if someone could help me out wiht a little issue i'm having.

I have a database field which is p8, and it contains # of minutes.

I need to convert those minutes into hours and minutes, but because it's a packed number i keep running into problems.

Please advise. Smiler

Thanks Smiler


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
susannah
Expert
posted Hide Post
Zu,
if you translate it to Integer, what happens?
DEFINE FILE whatever
MINUTES/I8=originalfield;
END



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
MadamZuZu
Gold member
posted Hide Post
i change it to int, and then try to do IMOD on it... to get the remainder (minutes) when i devide by 60... but i get some mumba jumbo...
am i using the function wrong? i feel like it's a little typo that i can't see. Frowner


TOT_MIN_WRK/I8 = IMOD(MINUTES, 60, TOT_MIN_WRK);

as the output i get:
minutes:26
tot_min_wrk:26

...? Frowner


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
susannah
Expert
posted Hide Post
well, hmm.
whats the input value?
if the input value is 26, then the mod 60 of 26 would be... 26.
so it looks good to me, what am i missing?



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
MadamZuZu
Gold member
posted Hide Post
im sorry, bad example.

if i have input of 78, the IMOD also gives me 78, where it should be 18, right?

basically, no matter what the input it, i get the same number back


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
MadamZuZu
Gold member
posted Hide Post
I tired changing the 60 to a 5, and it works...

Confused


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
Prarie
Virtuoso
posted Hide Post
Welcome to Focus...whatever works. Smiler


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
MadamZuZu
Gold member
posted Hide Post
hehe, thanks Smiler
but i dont need what works, i need what doesn't! Smiler


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
susannah
Expert
posted Hide Post
Zu,
-SET &NEW = IMOD ( 78 , 60 , 'I5');
-TYPE &NEW
DEFINE FILE CAR
NEWSALES/I6= IMOD (SALES , 60, 'I6');
END
 
TABLE FILE CAR
PRINT SALES NEWSALES  BY COUNTRY BY CAR

both work fine for me.
what version are you in?

This message has been edited. Last edited by: susannah,



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
MadamZuZu
Gold member
posted Hide Post
Edit: Thanks Smiler i think i got it

This message has been edited. Last edited by: MadamZuZu,


~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~
PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server)
TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
 
Posts: 74 | Location: Gaithersburg, MD | Registered: August 08, 2006Report This Post
susannah
Expert
posted Hide Post
well, sure. you could be referencing the wrong horizontal instance of a verb object.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report 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     Packed Numbers and Time Conversions

Copyright © 1996-2020 Information Builders