topic Date insert to Oracle table Issue Base SAS Date in SAS Procedures

Date insert to Oracle table Issue Base SAS Date

Jyuen204 — Fri, 16 Oct 2020 15:40:16 GMT

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 into ORACLEDB.ORACLETABLE(CDM_ID, DWELLING_ID, UNIQUE_KEY, MGMT_DT)
(select CDM_ID, DWELLING_ID, UNIQUE_KEY, today() format=YYMMDDD10. as MGMT_DT from SASVOLATILETABLE);
run;

This however is passing off a zero so I am getting Jan 1 1960 in my Oracle Table

Re: Date insert to Oracle table Issue Base SAS Date

Reeza — Fri, 16 Oct 2020 16:21:04 GMT

I think you need a datetime, not a date? Try replacing today with datetime() and not applying a format or using a datetime format.

(select CDM_ID, DWELLING_ID, UNIQUE_KEY, datetime() format=datetime22. as MGMT_DT from SASVOLATILETABLE);

Re: Date insert to Oracle table Issue Base SAS Date

Jyuen204 — Fri, 16 Oct 2020 16:23:51 GMT

Thank you so much Reeza!