Thanx for the ideas folks:

The solution below with an extra column viewable and supported in remedy with a character conversion seems the most appealing.

---Bal

-----Original Message-----
From: Jeff Hodges [mailto:jeffery.hodges@CITICORP.COM]
Sent: Tuesday, December 31, 2002 10:56 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: 5.x Question


I have ran into this one before. What I did was convert the database date
field to a character field using the dbconversions.

To implement it.

1) Create a database view of the database table, with an additional column
which has the character conversion.
Use the following syntax to convert the Oracle date to a character. This one
is nice since it does the timezone conversion for you.
select tochar(newtime(TODATE('01/01/1970 00:00:00','MM/DD/YYYYHH24:MI:SS')+
(dateint/(60*60*24)), 'GMT', 'PDT'), 'MM/DD/YY HH24:MI:SS') from testnum ;

2) Create the Remedy View against the database view.

Check the Remedy KB #311 for more details on the conversion.

-jeff

-----Original Message-----
From: erashid [SMTP:erashid@WCOM.CA]
Sent: Tuesday, December 31, 2002 9:09 AM
To: ARSLIST
Cc: erashid
Subject: Re: 5.x Question

Dear Baljinder,

REMEDY CONSTRAINT :
According to the document on view forms, Remedy does not
recognize date datetypes. This probably explains why the
data field does not appear as part of the field selection.

A SOLUTION :
You can try creating a complementary varchar2 or number
field (which Remedy does support) to redundantly store the
date information and have it appear on the form.

You can use a database trigger if you wish to keep all of
this at the db end instead of having a solution mix of db
and Remedy.


Sincerely,

El-Noor



On Mon, 30 Dec 2002 15:48:47 -0500
Baljinder Samrai wrote:
>Hello,
>
>I have a question and would like to get some responses on
>a possible solution.
>
>I have created a view form for an oracle table. However,
>I am not able to select an oracle date field to be
>visible on the view form in our remedy application. Does
>anyone have any ideas on how it may be possible to view
>an oracle date field in a Remedy view form.
>
>
>
>Thank you,
>
>Baljinder Samrai
>Systems Analyst
>Adelphia Communications Corporation
>716-819-6137 (Office)
>"Success is mandatory"
>
>
>
>

>You may control your subscription options, including
>UNSUBSCRIBE,and ACCESS THE ARCHIVES at
>http://www.ARSLIST.org. For ARSList support, please send
>eMail to support@arslist.org



You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE
ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to
support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org