<div>
do i have to do this in custom transformer or can i use in expression<br />
my data is in table i am using 4.2.1 i mean what kind of transfomer is need to it ?
</div>


<div>
You're using DI Studio? &nbsp;I'm not familiar enough with it to say how to do it, but all you're doing is creating a new variable. &nbsp;You already have the date and time variables d1, d2, t1, and t2 so just create a new variable using this formula..<br />
<br />
minutesDiff=intck('minute'<wbr />,<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dhms(d1, hour(t1), minute(t1), second(t1)),<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;dhms(d2, hour(t2), minute(t2), second(t2)));
</div>


<div>
ok can we do minutesdiff in sql tht will be easy
</div>


<div>
there's a function similar to minutesdiff in sql which is shown in &nbsp;d507201's 1st post;<br />
<br />
&nbsp; ** Calculate the difference in minutes. ;<br />
121 &nbsp; &nbsp; minutesDiff=intck('minute'<wbr />,sasdt1,sa<wbr />sdt2);<br />
<br />
the only thing is that because your date and time are in different fields, some processing needs to be done to put the 2 values into 1 field before you can use the function. I'm sure this is the similar case in sql. 
</div>


<div>
its not liking intck function<br />
<br />
W5ZXHLPB.em_proc_tme_zone length = 8,<br />
&nbsp; &nbsp; &nbsp; W5ZXHLPB.eventdatetime length = 8,<br />
&nbsp; &nbsp; &nbsp; W5ZXHLPB.processdatetime length = 60,<br />
&nbsp; &nbsp; &nbsp; W5ZXHLPB.transmitdatetime length = 8,<br />
&nbsp; &nbsp; &nbsp; INTCK('MINUTE',W5ZXHLPB.pr<wbr />ocessdatet<wbr />ime ,W5ZXHLPB.eventdatetime )<br />
&nbsp; &nbsp; &nbsp; &nbsp;as evt_to_em_proc_tme_lag length = 8<br />
<br />
put &quot;WARNING%QUOTE(:) Mapped source columns do not match columns used in&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;&nbsp;expression<br />
<br />
but columns are there
</div>


<div>
W5ZXHLPB.processdatetime length = 60,<br />
&nbsp;<br />
This tells me that the varible is character. &nbsp;It needs to be numeric, length=8 like eventDateTime.
</div>


<div>
when i do<br />
dhms for 2011-04-25 20:56:38<br />
ouput comes<br />
<br />
1619384198<br />
what this number means
</div>


<div>
apply format datetime. (datetime with a period at the end of it) to the format column of the corresponding record.<br />
<br />
this is the time in seconds elapsed since 01 Jan 1960 midnight.<br />
<br />
also, using DI studio, it will prompt you when columns are not mapped properly. just drag the 2 columns you need into the target column. however, if you don't do so it won't harm the code flow...
</div>


<div>
<div class="content wysiwyg-content">
i want to get time in minutes <br />
<br />
i have pdate 2011-04-21(ddmmyy10.) and ptime 2:38:23(time8.)<br />
then &nbsp; sdate 2011-04-20(ddmmyy10.) and stime 11:01:41(time8.)<br />
<br />
i want to get time in minutes between pdatetime and sdatetime<br />
if negative values the null it<br />
<br />
Thanks
</div>
</div>


i want to get time in minutes 

i have pdate 2011-04-21(ddmmyy10.) and ptime 2:38:23(time8.)
then   sdate 2011-04-20(ddmmyy10.) and stime 11:01:41(time8.)

i want to get time in minutes between pdatetime and sdatetime
if negative values the null it

Thanks

get time in minutes

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.