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
