Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't make this insert
Jordi,
You are trying to force a character field
(TO_CHAR(sysdate,'DD-MM-YY')
into your tiempo column, which is a DATE format.
Use trunc(sysdate[,'DD']) (which is date format) or TO_DATE('value'[,'date_mask'])
HTH
-- Chrysalis FABRICATI DIEM, PVNCReceived on Sun Aug 17 1997 - 00:00:00 CDT
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"