Thomas,
This worked.
Thanks a Bunch! I appreciate your assistance.
Audrey
----- Original Message -----
From: Thomas Bean <[EMAIL PROTECTED]>
Date: Thursday, October 19, 2006 4:43 pm
Subject: Re: Convert Remedy Date/Only Field
> Audrey,
> Oracle has built-in functions that can handle this type of
> conversion. The
> following syntax should convert the integer value from a Remedy
> date field
> ('remedy_date' in this example) to a recognizable date.
>
> SELECT TO_CHAR(TO_DATE(remedy_date, 'J'), 'MON-DD-YYYY') FROM DUAL;
>
> --Thomas
>
> ----- Original Message -----
> From: "Audrey H Franklin" <[EMAIL PROTECTED]>
> Newsgroups: gmane.comp.crm.arsystem.general
> Sent: Thursday, October 19, 2006 14:24
> Subject: Re: Convert Remedy Date/Only Field
>
>
> > Thomas,
> >
> > I am working with Oracle 9i database.
> >
> > Will look for your post on the ARSLIST.
> >
> > Thanks,
> >
> > --Audrey
> >
> > ----- Original Message -----
> > From: Thomas Bean <[EMAIL PROTECTED]>
> > Date: Thursday, October 19, 2006 3:16 pm
> > Subject: Re: Convert Remedy Date/Only Field
> >
> >> Audrey,
> >> From what type of database are you reading the date values? I
> >> have
> >> previously posted date field conversion functions for MS-SQL,
> >> Oracle, and
> >> Informix. You can find these in the ARSList archives under a
> >> thread titled
> >> "Integer date conversion in Business Object WebIntelligence", from
> >> late last
> >> month.
> >>
> >> --Thomas
> >>
> >> ----- Original Message -----
> >> From: "Audrey Franklin" <[EMAIL PROTECTED]>
> >> Newsgroups: gmane.comp.crm.arsystem.general
> >> Sent: Thursday, October 19, 2006 13:21
> >> Subject: Convert Remedy Date/Only Field
> >>
> >>
> >> > Good Afternoon,
> >> >
> >> > I am trying to convert Remedy Date/Only field to a date for
> >> reporting> purposes, and discovered that the Date/Only field
> >> stores date information
> >> > as the number of days from the beginning of its range relative
> >> to 1/1/4713
> >> > B.C.
> >> >
> >> > Is there a script that I can use to convert the Date field data
> >> to a date?
> >> >
> >> > Any assistance is greatly appreciated.
> >> >
> >> > Many Thanks.
> >> >
> >> > Audrey Franklin
> >> > Senior Systems Analyst
> >> > New York University
> >> > [EMAIL PROTECTED]
> >> >
> >>
> >>
> >
>
_______________________________________________________________________
> ________
> >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
> >>
> >
>
>
_______________________________________________________________________
________
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
