Re: sql date bug in trigger

[Quoted] try "MI" for minutes instead of "MM" for Month.

"Jim" <infosys_at_NOSPAM.medfab.com> wrote in message news:a34ee4$ddc$1_at_nnrp.atgi.net...
> Hi all
>
> While attempting to create some relatively simple triggers placing output
> into a table with a date and time stamp I discovered that the minute
portion
> 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
> 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 - 23:29:47 CET