Eric, Remedy Date fields are Julian date. I have used this oracle function to cover this type of data to a date value. Just use the 'J' flag with oracle TO_DATE function.
TO_DATE(REQUESTED_DATE,'J') AS REQ_DATE Hope this helps! Debra -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Eric Zhang Sent: Monday, June 14, 2010 11:58 AM To: [email protected] Subject: Difference between DATE and DATE/TIME Hi, listers. Does anyone know how DATE is stored in AR System database (Oracle)? I understand DATE/TIME type filed is stored as seconds since 1/1/1970, but what about DATE type field? I am trying to create a view in Oracle using the following formula: new_time(to_date('01/01/1970 00:00:00','MM/DD/YYYY HH24:MI:SS')+ (t_schemaid.c_column_num/(60*60*24)),'GMT','CDT') My_Date_Time If the filed is of DATE/TIME data type, the formula works perfectly. However, if the filed is of DATE data type, it gives the wrong Date. Thanks, Eric ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
