> > The DATE datatype in Oracle is stored in a special internal format. > (Specifically, it's a floating point number representing the > number of days > since some point in time.) As I said before, the formatting > only comes > into play when you retrieve the value, not when you store it. > > If you want to use the same date/time in two tables, you should select > SysDate from Dual first, and insert that value into both tables.
Ok, that answers my question!! so would i just capture the literal value from the select and insert that value into both tables? Thanks Ronald !!
