Hi Prasad,
In the DataObject, use a computed column of type String instead of
directly binding to the date field in the database. Looks like ND is trying
to pull out a Datetime out of the already formatted string you get from the
database. You may not need the Partial_Override stuff. While adding a
computed column you can specify
TO_CHAR(DateField, 'MM/DD/YYYY HH:MM PM') || ' CST'
Regards,
Aby
> -----Original Message-----
> From: Moganna, Prasad [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, May 05, 1999 11:12 AM
> To: '[EMAIL PROTECTED]'
> Subject: [ND] Changing the format of Date Time field associated to a
> datao bject
>
>
> I have a dataobject having 5 fields. One among them is a date time
> field. This dataobject
> is bound to a repeated object in a ND page. The repeated object has 5
> display fields all of which
> are href's. The requirement is the date time object should be formatted
> like
> this:
> 'MM/DD/YYYY HH:MM PM ' CST
> Eg: 05/05/1999 10:00 AM CST
>
> I have set the partial text override and the sql text select is being
> overwritten in the wizard
>
> whenever I give TO_CHAR(DateField, 'MM/DD/YYYY HH:MM PM') || ' CST' , it
> gives me the following
> software messages in my page.
>
> doWFRptDetail.convertDataFieldValue: Unexpected Exception
> (spider.session.CSpDatetimeParsingException: parseTimeFromString: invalid
> substring (CST) when
> parsing '09:05 AM CST' [null]) caught in 'doWFRptDetail'
> Top of stack: |spider.session.CSpDatetimeParsingException:
> parseTimeFromString: invalid substring (CST) when parsing '09:05 AM CST'
> [null] at
> java.lang.Throwable.<init>(Compiled Code) at
> java.lang.Exception.<init>(Compiled Code) at
> spider.util.CSpSpiderException.<init>(Compiled Code) at
> spider.util.CSpSpiderException.<init>(Compiled Code) at
> spider.session.CSpValueConversionException.<init>(Compiled Code) at
> spider.session.CSpDatetimeParsingException.<init>(Compiled Code) at
> spider.session.CSpDatetime.parseTimeFromString(Compiled Code) at
>
>
> Can anyone please help me on this.
>
> Thanks in advance,
>
> Prasad
> _________________________________________________________________________
>
> For help in using, subscribing, and unsubscribing to the discussion
> forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
>
> For dire need help, email: [EMAIL PROTECTED]
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
