Oracle 8.0.5 DATE Type

From: Greg Akins <insomnia_at_a1usa.net>
Date: Tue, 08 Jun 1999 05:30:53 -0800
Message-ID: <928848654.3223@www.remarq.com>

I am trying to update a table. The attribute is CLOSE_DT defined as type DATE.

There are two distinct values '06/08/99 6:59' and '01/01/01 6:59' (for example). I want to truncate the dates to remove the time component.

Update TABLE1 set close_dt = trunc(close_dt) ;

Now I have two values '01/01/01 12:00AM' & '06/08/99 7:00AM'.

Notice the time gets updated to current time, but not truncated.

Any ideas?

-greg -> insomnia_at_a1usa.net

Received on Tue Jun 08 1999 - 08:30:53 CDT