It is stored as the same value as the Oracle Julian date ( date format of 'J' ).
Date and time fields There are three types of date and time fields: - Date/time fields: Store calendar dates and time together. You can set the display type to Date Only or Time Only so that the user sees only the date or time. AR System stores date/time values as the integer number of seconds since 00:00:00 GMT, January 1, 1970. Dates from January 1, 1970 through January 18, 2038 GMT are valid in date/time fields. If the user enters only a time, then the current date is assumed. If the user enters only a date, then the time defaults to 12:00:00 AM. - Date fields: Store date information only, as the number of days from the beginning of its range. Use a Date field when you want to compare two dates or perform calculations based on the date, such as calculating the number of days between two dates. Users can enter dates from January 1, 4713 B.C. to January 1, 9999 A.D. in the Date field. - Time fields: Store time information only, as the number of seconds from 12:00:00 AM. Use a time field to compare two times or perform calculations based on time, such as the number of seconds elapsed. The value in a time field is independent of the time zone. While a date/time field adjusts the displayed value to reflect the user's time zone, the time value in a time field remains unchanged when displayed on the client. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Eric Zhang Sent: Monday, June 14, 2010 1:58 PM 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"
