I have the following code :
proc sql;
insert into ora.sas_ora_out( date_col)
values('14-NOV-11');
quit;
However, I get this error:
ERROR: Value 1 of VALUES clause 1 does not match the data type of the
corresponding column in the object-item list (in the SELECT
clause).
Since you are running the SQL in SAS try using SAS syntax for specifying a date literal.
'14NOV2011'd
Thanks Tom.
That will work but I am trying to find out the correct format.
Actual problem is with a DI job I am creating which needs to insert current date into an Oracle date column. I have used date() function but I am getting 01 Jan 1960 .
Did you try a datetime value?
'14NOV2011:00:00'dt
Yes
'14NOV2011:00:00'dt
works -- incidently '14NOV2011'd would not work.But I want to use date() or datetime() function in the insert clause / DI job
Oracle only has the DATETIME type. So use datetime() function. Or other functions that generate datetime values like dhms().
Since a single column is changing I read the request as an UPDATE, rather than INSERT which only adds rows (iirc)
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.