Thanks, Debra! That works great.
-Eric On Mon, 14 Jun 2010 09:04:30 -0700, Anderson Debra (PRN) <[email protected]> wrote: >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" >======================================================================== _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
