Why Oracle is not adding a second to date/time:

From: <zigzagdna_at_yahoo.com>
Date: Thu, 5 Feb 2009 14:49:47 -0800 (PST)
Message-ID: <8b2bac4a-fb46-4b33-b35a-0ef45c8c7a9f_at_v39g2000pro.googlegroups.com>

I am using Oracle 10.2 on HP UNIX 11i

I have table lasttime with a column runtime (of type date)./ select * from lasttime;

   02/04/2009 22:35:38
I want to add one second
to runtime. I am unable to do it using following statement:

Update lasttime set runtime = to_date('20090204223538', 'YYYYMMDDHH24MISS') + 1/(24 * 60 *60); It still shows me:
select * from lasttime;

   02/04/2009 22:35:38

I can always add a minute or hour but second does not work. I do not know what I
Am doing wrong? Received on Thu Feb 05 2009 - 16:49:47 CST

Original text of this message