Hello i've another problem with the type date.
What's the syntax of insert in this type?
I've the table:
film wit the column data_catalogo date and I want to insert a value but I don't say how.
Thank You, Elisa

Which DBMS? Oracle, SQL Server, Access, ...?

Oracle 9i,
thank you.

In that case, you need to use the TO_DATE function with a VARCHAR2 date value and a format mask, e.g.:

insert into mytable( date_col ) values ( TO_DATE('01-SEP-2003','DD-MON-YYYY') );

insert into mytable( date_col ) values ( TO_DATE('01/09/2003','DD/MM/YYYY') );

insert into mytable( date_col ) values ( TO_DATE('2003/09/01 16:42:00','YYYY/MM/DD HH24:MIS') );