Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
60 results
Sorted by:
09-25-2016
08:39 AM
Hello,
i want to insert a SAS Date from a SAS Table into a Oracle Date-column.
I searched already in Google and in this forum - but i get always:
ERROR: Value 7 on t...
12-01-2016
01:34 PM
I wanted to get the current date & time to insert in one of the attributes of ORacle Table.
I tried below 2 options & i am getting default date of SAS.
Option 1...
03-28-2023
03:23 PM
Hi Team, I tried a lot to insert sas date value into oracle date variable, but always giving ERROR: Oracle execute error: ORA-0140: Cannot insert NULL into oracle table DATE field. Below is m...
07-19-2020
11:32 PM
Hi All, I am using simple code to insert date field into oracle date field and it is inserting as 01JAN1960. All other fields are inserging fine other than Date field which is inserting as 0...
08-02-2017
11:03 AM
...INTO oraCon.TABLENAME
(
LAST_UPDATE
)
VALUES
(
'01JAN2016:00:00:00'DT
);
disconnect from oracle;
quit;
But how can i insert sysdate/datetime (the a...
10-16-2020
11:40 AM
Sorry guys, having an issue. I am inserting records into an Oracle database Table and one of the fields is todays date which I am writing as a datestamp for historical reference. proc sql; insert...
03-17-2020
04:29 PM
For some reason when I try to write this SAS table to and Oracle table of time date the date in the oracle table shows 1960. I know I'm missing something simple.
proc sql;
create t...
10-31-2012
12:57 PM
Hi! Please, how to insert current date via INSERT in a oracle table by SAS libname? This column is a date (data type, but have hours too) on oracle, and date9. (format and informat) on SAS. Im t...
04-23-2018
11:46 AM
...apping them to insert into another oracle table. Proc Sql; Connect To Oracle(User=&Myid Orapw=&Mypwd Path="&Mydb"); Create Table Test as S...
12-16-2016
08:13 PM
Hi SAS users, A filed "ENTRY_DT" is built as date format in Oracle Database, i am trying to load current date in YYYY-MM-DD format . I tried to convert it into character with put f...