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"
