Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
0%
200 - 500 GB
25%
500 - 800 GB
0%
800 - 1200 GB
0%
1200 - 1500 GB
0%
1500 - 2000 GB
75%
> 2000 GB
0%
Total votes: 4

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th July 2018, 10:09
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 199
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
visual hr:mn:se conversion
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: Both

hi,

anybody know how to convert long results of system time.num() into hr:mn.se visually like 17:10:00 or 5:10 PM whichever? i can't find any function like date conversion date.to.utc(), I need num.to.time(), does any function similar to this? thanks.

regards,
jojo
Reply With Quote
  #2  
Old 26th July 2018, 10:41
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,721
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
utc.to.date()

Hello,

Code:
utc.to.date()
Syntax:

function long utc.to.date  (long utc, ref long yearno, ref long monthno, ref long month_dayno, ref long hours, ref long minutes, ref long seconds)

Description

This converts a UTC long format value to the corresponding year, month, day, and so on, in local time.

Arguments

long utc  
ref long yearno  
ref long monthno  
ref long month_dayno  
ref long hours  
ref long minutes  
ref long seconds
__________________
//Bernd
Reply With Quote
Sponsored Links
  #3  
Old 26th July 2018, 12:41
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 199
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
thanks for reply. is there anything like num.to time() bec i need only to convert the time created by time.num() function.
Reply With Quote
  #4  
Old 26th July 2018, 14:25
Juergen's Avatar
Juergen Juergen is offline
Guru
 
Join Date: Aug 2001
Location: Germany
Posts: 579
Juergen is on a distinguished road
Baan: IVc4, ERP LN - DB: Oracle - OS: Linux, Unix
Hello,

maybe can also be done simply by
Code:
long    x.std
long    x.min
long    x.sek
string  x.time(8)

x.std = time.num() / 3600
x.min = (time.num() - (x.std * 3600)) / 60
x.sek = time.num() \ 60

x.time  = sprintf$("%02d:%02d:%02d",x.std,x.min,x.sek)
Regards,
Juergen
Reply With Quote
  #5  
Old 26th July 2018, 15:12
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 199
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
thanks Juergen. i will try this.
Reply With Quote
  #6  
Old 7th August 2018, 14:57
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 199
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
thanks, it works.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Umlauts in PCL to PDF conversion litrax Tools Development 8 17th July 2018 07:58
Execute AFS from Visual Basic 6 amitsdotcom Tools Development 3 17th February 2011 15:25
EDI - Item Code Conversion In shaboo Distribution, Transportation & Warehousing 2 12th April 2006 14:16
Lot-wise conversion rates agt.std conversion VilasoorRavi Distribution, Transportation & Warehousing 3 13th February 2006 08:35
Urgent help req -Customized Item Conversion factor noorulhaq Manufacturing & Supply Chain 0 7th June 2003 07:32


All times are GMT +2. The time now is 17:14.


©2001-2018 - Baanboard.com - Baanforums.com