Dear all

I used Baan IV b2 version and I want to convert transaction time in tfgld410 to be format hh:mm:ss. If I dont wrong, in the baan have a function tfgdl0032(). how to use that function ?

thanks you

Hi,

you will have to use:
function long itfgld0032.num.to.time(domain tctime trans.time).

For return value use a long domain with display format 99:99:99.

Best regards

nikos

Everyone

There are many of us who do not have either license, experience or in my case Desire to use Baan tools to Report and analyze Baan Data.

For myself, I use Oracle to access my Baan data using SQL either in a standard SQL Query or a SQL Query setup as an Excel .DQY file.

Although this may not be the place, for the sake of those who need to translate Long Baan Times to formated strings, I created the SQL to accomplish this with Oracle.

Because it uses Oracle functions, this will only work with Oracle.

What is below was copied from one of my SQL statements that will format the time.

lpad(trunc(t$trtm/60/60,0),2,0)||':'||
lpad(trunc((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60),0),2,0)||':'||
lpad(round((((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60)-(trunc((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60),0)))*60),0),2,0) "TrxTime",

Roy

Everyone

There are many of us who do not have either license, experience or in my case Desire to use Baan tools to Report and analyze Baan Data.

For myself, I use Oracle to access my Baan data using SQL either in a standard SQL Query or a SQL Query setup as an Excel .DQY file.

Although this may not be the place, for the sake of those who need to translate Long Baan Times to formated strings, I created the SQL to accomplish this with Oracle.

Because it uses Oracle functions, this will only work with Oracle.

What is below was copied from one of my SQL statements that will format the time.

lpad(trunc(t$trtm/60/60,0),2,0)||':'||
lpad(trunc((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60),0),2,0)||':'||
lpad(round((((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60)-(trunc((((t$trtm/60/60)-trunc(t$trtm/60/60,0))*60),0)))*60),0),2,0) "TrxTime",

Roy

You have a desire to use Oralce PL/SQL. :)