Date insert to Oracle table Issue Base SAS Date

[Jyuen204]

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

[Reeza · Accepted solution]

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);

[Jyuen204]

Thank you so much Reeza!