Desktop productivity for business analysts and programmers

Problem in insert query

Reply
Contributor
Posts: 42

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?

Esteemed Advisor
Esteemed Advisor
Posts: 7,221

Re: Problem in insert query

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
  • 93 views
  • 1 like
  • 2 in conversation