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 table test1 (academic_period_time date); quit; proc sql; insert into test1(academic_period_time) values('05MAY2023'D,); quit;
Oracle stores datetimes, not dates.
SAS should translate for you, but seems not to here.
Try
insert into test1(academic_period_time) values('05MAY2023:0:0'dt);
Oracle stores datetimes, not dates.
SAS should translate for you, but seems not to here.
Try
insert into test1(academic_period_time) values('05MAY2023:0:0'dt);
Yes. You are missing the fact that Oracle does not actual have a DATE data type. It only has DATETIME. Any reasonable number of days will look like some time early in the morning of January first 1960.
I would work better to just use SAS code to add data, but if you want to use the SQL INSERT statement then give it a datetime value.
values('05MAY2023:00:00'DT)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.