All Forums Database
Det7 36 posts Joined 10/08
01 Jan 2009
Cannot Insert Feb 29 2009 Leap Year value

Why can't I insert a '2008-02-29' value to a DATE FORMAT 'YYYY-MM-DD' column?

Adeel Chaudhry 773 posts Joined 04/08
01 Jan 2009

Hello,It works fine. What error are you facing? Following example may be of some help:CREATE VOLATILE TABLE Table1 (col1 DATE FORMAT 'YYYY-MM-DD') ON COMMIT PRESERVE ROWS;INSERT Table1 VALUES ('2008-02-29');SELECT * FROM Table1;Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

02 Jan 2009

We can insert this date in table. Please find below query.database xyz;create table testdate(d1 date);N.B-default date format is 'YYYY-MM-DD'insert into testdate values('2008-02-29')1 row processed.select * from testdate;d12008-02-29I tried it in Ansi as well as TD mode.Please explain what exactly you want?Regards,Ravi.

You must sign in to leave a comment.