https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-insert-query/m-p/367256#M24036 <P>I am trying to insert SAS data into Oracle using INSERT INTO query but I am facing one problem that,</P><P>I have one column (Which contains Different dates) in the dataset which has "<STRONG>Date9.</STRONG>" format and When I insert into Oracle database every observation in that column shows only "<STRONG>01JAN1960</STRONG>".</P><P>&nbsp;</P><P>What should I change in SAS programme&nbsp;or Oracle to fix this problem?</P> Thu, 15 Jun 2017 07:50:46 GMT india2016 2017-06-15T07:50:46Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-insert-query/m-p/367256#M24036 <P>I am trying to insert SAS data into Oracle using INSERT INTO query but I am facing one problem that,</P><P>I have one column (Which contains Different dates) in the dataset which has "<STRONG>Date9.</STRONG>" format and When I insert into Oracle database every observation in that column shows only "<STRONG>01JAN1960</STRONG>".</P><P>&nbsp;</P><P>What should I change in SAS programme&nbsp;or Oracle to fix this problem?</P> Thu, 15 Jun 2017 07:50:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-insert-query/m-p/367256#M24036 india2016 2017-06-15T07:50:46Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-insert-query/m-p/367262#M24037 <P>Please check teh search facility before posting questions, this has been asked numerous times before:</P> <P><A href="https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=insert+date+into+oracle" target="_blank">https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&amp;allow_punctuation=false&amp;q=insert+date+into+oracle</A></P> Thu, 15 Jun 2017 08:03:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Problem-in-insert-query/m-p/367262#M24037 RW9 2017-06-15T08:03:55Z