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
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