Desktop productivity for business analysts and programmers

Problem in insert query

Reply
Frequent Contributor
Posts: 79

Problem in insert query

I am trying to insert SAS data into Oracle using INSERT INTO query but I am facing one problem that,

I have one column (Which contains Different dates) in the dataset which has "Date9." format and When I insert into Oracle database every observation in that column shows only "01JAN1960".

 

What should I change in SAS programme or Oracle to fix this problem?

Super User
Super User
Posts: 9,838

Re: Problem in insert query

Posted in reply to india2016

Please check teh search facility before posting questions, this has been asked numerous times before:

https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&...

Ask a Question
Discussion stats
  • 1 reply
  • 122 views
  • 1 like
  • 2 in conversation