Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't make this insert

Re: Can't make this insert

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/08/17
Message-ID: <33F75404.3C32@iol.ie>#1/1

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, PVNC

('To Protect and to Serve')
Terry Pratchett : "Guards Guards"
Received on Sun Aug 17 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US