Re: DATES

In article
<204285895F88D1118FAC00A0C933CDDF47279B_at_mail.silverstream.com>,   "Caroline Levis" <clevis_at_tcd.ie> wrote:
> I am getting the following error
> ERROR: com.sssw.rt.util.AgoApplicationException: Invalid argument.
> I think it is to do with a date
> the database is oracle. I have declared the variable as date
> but my program will not update an oracle table using date - it will
however
> display any dates in database as type datetime
>
> any ideas
>
> Caroline
>

I am totally unfamiliar with com.sssw.rt.util.AgoApplicationException, but since there are no replies on this thread I thought I would respond with a couple of general date points.

Oracle expects when using SQLPlus or Pro* languages that all date values submitted to it to be character strings enclosed in single quotes in the default nls_date_format which is normally 'DD-MON-YY' or to be included in a to_date(variable,'format') function call.

When you select a date it will be in the default format unless a to_char (variable,'format') function is used to format the results.

I hope this helps.
--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Mar 04 2000 - 13:04:16 CST