Re: how to change dates or times in a oracle date time field

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 19 Jun 2002 15:18:07 GMT
Message-ID: <3D10A09E.15E98EE5@exesolutions.com>

jim agans wrote:

> hi I have a QUESTION ON HOW TO ADD time to a oracle date field.
>
> What I would like to do is this:
>
> I would like to add some minutes to a date-time field ...the field looks like this
> 27-MAY-1999 12:01:01 AM
>
> HOW DO ADD like 8 minutes to this value and update??
>
> thanks
> jim agans

A better question would be how to get rid of the time in a date field ... because you can not. Time is always there.

Go to any table with a date field and type the following:

SELECT TO_CHAR(date_field_name, 'DD-MON-YYYY HH:MI:SS') FROM table_name;

Daniel Morgan Received on Wed Jun 19 2002 - 10:18:07 CDT