Write Date from SAS to Oracle

[DavidPhillips2]

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;

[ChrisNZ · Accepted solution]

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

[Tom]

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)