dilemma

From: Reiro <ReiroGP_at_gmail.com>
Date: 13 Mar 2006 02:26:46 -0800
Message-ID: <1142245606.502944.30450@u72g2000cwu.googlegroups.com>

We have a test database with 2 fields STart_date_time and end_date_time.
format of the fields are timestamp example: 27/OCT/05 05:50:00

Start_date_time                         end date time

27/OCT/05 05:50:00                      27/OCT/05 06:44:00
27/OCT/05 06:44:00                      27/OCT/05 07:30:00
27/OCT/05 07:30:00

27/OCT/05 08:00:00
27/OCT/05 09:50:00 we want the start time of row 1 to have the end time of row 2. Start_date_times are already
populated in the database and End_date_time columns are empty.

plz help...

P.S thanx in advance. Received on Mon Mar 13 2006 - 04:26:46 CST