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)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.