Date fields are stored as the number of Days since January 1, 4713 B.C. (which also happens to be the Oracle Julian format) DateTime fields are stored as the number of seconds since January 1, 1970 (aka: The Unix or Epoch date) with relation of the server to GMT Time fields are stored as the number of seconds since Midnight (From the 6.3 Basic Guide) Fred
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shyam Attavar Sent: Thursday, April 19, 2007 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: Question regarding "Date" field NOT the "Date-Time" field ** Joe/Frank, The BO universe has been setup a while back pointing directly to the DB views & does not go through the ODBC Driver. I do not have the privilege to change this at the moment, since that application is owned by another department. Also, if the connection is through the ODBC driver, then the reporting load is handled by the AR Server (along with the other load it has to handle from the AR Clients) and not the DB directly. So, from a performance stand point I believe the current setup is desirable. If anyone believes that my understanding is incorrect, please feel free to correct me. In any case, understanding what the integer value means in the Date field would really be helpful. Cheers, -- Shyam ----- Original Message ----- From: Joe D'Souza <mailto:[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Wednesday, April 18, 2007 8:45 PM Subject: Re: Question regarding "Date" field NOT the "Date-Time" field ** To the best of my knowledge, no, but a workaround could be to create that join internally within the ARS and then report from BO out of that join.. Another alternative could be to create the join from the DB, create a view form in the ARS from that join created in the DB, and then connect to BO using the AR System ODBC driver and report out of that view... There might be other options around too but I'm not feeling too creative right now it being nearly 11:40 PM... Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Frank Caruso Sent: Wednesday, April 18, 2007 7:44 PM To: arslist@ARSLIST.ORG Subject: Re: Question regarding "Date" field NOT the "Date-Time" field ** Will the ARS ODBC driver allow the joining of tables(views)? I know it does not in excel, access and crystal. Does it work different in Business Objects? On 4/18/07, Joe D'Souza <[EMAIL PROTECTED]> wrote: ** Is there any specific reason why you are not using the AR System ODBC driver to view the data tables? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Shyam Attavar Sent: Wednesday, April 18, 2007 7:10 PM To: arslist@ARSLIST.ORG Subject: Question regarding "Date" field NOT the "Date-Time" field ** Dear listers, I am trying to run reports through Business Objects universe that directly points to the Remedy views in the Oracle DB. However, there is one field that is created as a Date field and I would like to convert the data stored in this field to something more meaningful in Business Objects. I was wondering if there is some calculation any of you have readily available to do this conversion. Any pointers in this regard would be really helpful and much appreciated. Thanks in advance. Cheers, -- Shyam __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"