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)
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: