Re: sql date bug in trigger

[Quoted] Of course thats it!

Thanks.

"Paul Quenneville" <paulq_at_rogers.com> wrote in message news:vhk58.6744$bIE.254_at_news1.bloor.is...
> 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:55:59 CET