I have a temporary table and want to insert data from another table, but If I try to convert using the ERROR: Price is not valid for an «/ A» «DDA» How can I set the cell to poblated when the temp In the
date type, and
column in usomultiple is a
varchar .
to_date () function, I get an error because thousands of cells have been found to be
'/ /' Was empty as the value.
temporarily from INSERT (cd_id, ds_estado, Dt_date) Select um.cd_uso, um.ds_estado, to_date (um.dt_dateIn, 'dd / MM / yyyy') from our liberalities;
'/ /' and the correct value is set instead?
TO_DATE (NULLIF (dt_dateIn, '//'), 'dd / MM / yyyy ')
No comments:
Post a Comment