<div>
 
You didn't specify what format the date and time fields are stored in, so I can't be exact when giving you an answer. 
 
But, in a nutshell, you just convert the date and time fields to character-fields, pad them to the appropriate lengths, concatenate them ( probably using pipes ... || ...), turn them into a timestamp using the TIMESTAMP function, then calculate the difference using the TIMESTAMPDIFF function. 
 
If you need more detail, please post the data-types of your fields and some sample data. 
 
HTH, 
DaveSlash 

</div>

<div>
the fields type are date and time. here are some examples. I'll try your suggestion, see if i make it work. Is TIMESTAMP requesting a specif format as an argument, date-time or date time? 
 
Thanks, 
 
Steli 
 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:38AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:38AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:42AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:42AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:42AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:42AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:43AM 
6/6/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:43AM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:21PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:21PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:22PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:22PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:22PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:22PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:24PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:24PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:25PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:25PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:26PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:26PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:26PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:26PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:27PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:27PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:27PM 
6/7/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;02:27PM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:51AM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;06:51AM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:51PM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:51PM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:51PM 
6/9/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:51PM 
6/10/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12:34AM 
6/10/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12:34AM 
6/10/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01:48AM 
6/10/2008 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;01:48AM 

</div>

<div>
 
Oops, let's try that first example again. It looked good when I pasted it, but it certainly doesn't now. 
 
SELECT TIMESTAMP( DATE('1988-12-25'), TIME('17.12.30') ) 
FROM &nbsp; SYSIBM.SYSDUMMY1
</div>

<div>
That worked great. I got the reference manual, also. 
 
Thanks.
</div>

<div>
<div class="content wysiwyg-content">
Hi all, 
 
I have a transaction table that stores date and time in different fields. I need to concatenate these 2 fields and then subtract the minimum from the maximum to see how much time was between the first transaction and the last one. Any idea of some functions I could use? 
 
Thanks.
</div>
</div>

Hi all,

I have a transaction table that stores date and time in different fields. I need to concatenate these 2 fields and then subtract the minimum from the maximum to see how much time was between the first transaction and the last one. Any idea of some functions I could use?

Thanks.

maximum date from concatenating date and time

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.