Date manipulations in VB6

[Palmero]

Hi all,
In Oracle V8i, I have the following table :

PRODUCT_CODE VARCHAR2(10)
START_TIME DATE
END_TIME DATE
DURATION NUMBER(6)

When performing a process for each product, I have to insert in the table, the system date before and after the process and the difference in seconds between START_TIME and END_TIME for the colum DURATION.

How to proceed in VB6?

Thanks in advance for your answer.

Palmero

 

[WarriorPrincess]

Use the DateDiff function to find the difference between the dates: DateDiff("s",date1,date2). The "s" means list the interval in seconds.

Use "Now" to get the system date.