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)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.