Re: Perl and Java and PL/SQL and SYSDATE

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 02 Dec 2004 02:04:55 GMT
Message-ID: <bLurd.52566$QJ3.27346@newssvr21.news.prodigy.com>

Malcolm Dew-Jones wrote:

> Craig & Co. (crb_at_amsa.gov.au) wrote:
>
>

[...]
>
>
> Why convert the date to a char and back to a date?
>
> surely #1 can be written simply as SYSDATE
>
> surely #2 can be written simply as TRUNC( SYSDATE )
>
> Whether this has anything to do with your problem,, I have no idea.
>

Good questions. In addition, what role does Perl play? -- you didn't post any relevant code.

Please describe your table. And version, platform too, while you're at it. And the setting of NLS_DATE_FORMAT.

You have no ORDER BY clause in your sample query, what makes you think that any particular order of returned results is guaranteed? How is MESSAGE_ID generated?

Elaborate on "every now and then". Can you reproduce the problem at will?

-Mark Bole Received on Wed Dec 01 2004 - 20:04:55 CST