sql date bug in trigger
From: Jim <infosys_at_NOSPAM.medfab.com>
Date: Mon, 28 Jan 2002 13:04:18 -0800
Message-ID: <a34ee4$ddc$1_at_nnrp.atgi.net>
[Quoted] Hi all
Date: Mon, 28 Jan 2002 13:04:18 -0800
Message-ID: <a34ee4$ddc$1_at_nnrp.atgi.net>
[Quoted] Hi all
While attempting to create some relatively simple triggers placing output [Quoted] into a table with a date and time stamp I discovered that the minute portion [Quoted] of "to_char(sysdate,'HH24:MM:SS')" was not updating correctly. By this I mean it would go from 12:01:58 to 5 seconds later it would be 12:01:03. I [Quoted] am still using Oracle version 7.3.2 and its on HP-UX10.20.
Has anybody seen this and if so what did you do short of upgrading Oracle?
TIA, Jim Received on Mon Jan 28 2002 - 22:04:18 CET