Hello,
i want to insert a SAS Date from a SAS Table into a OracleDate-column.
I searched already in Google and in this forum - but i get always:
ERROR: Value 7 on t...
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...
Hi Team, I tried a lot to insert sas date value intooracledate variable, but always giving ERROR: Oracle execute error: ORA-0140: Cannot insert NULL intooracle table DATE field. Below is m...
Hi All, I am using simple code to insertdate field intooracledate field and it is inserting as 01JAN1960. All other fields are inserging fine other than Date field which is inserting as 0...
...INTO oraCon.TABLENAME
(
LAST_UPDATE
)
VALUES
(
'01JAN2016:00:00:00'DT
);
disconnect from oracle;
quit;
But how can i insert sysdate/datetime (the a...
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...
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...
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...
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...
