<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
Hi John:<BR> <BR> The Oracle time component consists only of seconds, not fractions of a second while the PowerHouse DATETIME data type stores seconds to 3 decimal places. <BR>
<BR>
So it is a good idea to truncate the fraction of seconds. SYSTIME is an integer of the form HHMMSSHH i.e to the hundreths of a second<BR>
<BR>
i.e. Define X datetime = SYSDATE + ( FLOOR( SYSTIME / 100 ) ) /1000000<BR>
<BR>
Item date_time_column final X<BR>
<BR>
Good luck,<BR>
Peter Bateman<BR> <BR><BR><br /><hr />One at a time or all at once? Get updates from your friends in <a href='http://go.microsoft.com/?linkid=9660825' target='_new'>one place.</a></body>
</html>