Re: sql date bug in trigger

But ... why are you trying to store a datetime stamp as a VARCHAR2? Wouldn't it be a lot easier just to put SYSDATE into a DATE field?

Daniel Morgan

Jim wrote:

> 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 - 17:32:32 CET