11-14-2011 11:05 AM
I have the following code :
insert into ora.sas_ora_out( date_col)
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
11-14-2011 11:36 AM
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 .
11-14-2011 12:07 PM
'14NOV2011:00:00'dtworks -- incidently '14NOV2011'd would not work.
But I want to use date() or datetime() function in the insert clause / DI job
11-14-2011 12:16 PM
Oracle only has the DATETIME type. So use datetime() function. Or other functions that generate datetime values like dhms().