Storing data in Oracle date time columns

[Peter Bateman]

Hi John:
 
    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. 

 

   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

 

   i.e. Define X datetime = SYSDATE + ( FLOOR( SYSTIME / 100 ) ) /1000000

 

   Item date_time_column final X

 

Good luck,

Peter Bateman
 


_________________________________________________________________
One at a time or all at once? Get updates from your friends in one place.
http://go.microsoft.com/?linkid=9660827
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090508/8a7293c7/attachment.htm