HELP! Cannot Insert Feb 29 - Leap Year

UDA
Enthusiast

HELP! Cannot Insert Feb 29 - Leap Year

Why can't I insert a source date value which is 2008-02-29?
1 REPLY
Enthusiast

Re: HELP! Cannot Insert Feb 29 - Leap Year

We can insert this date in table. Please find below query.

database xyz;
create table testdate
(d1 date);

insert into testdate values('2008-02-29')
1 row processed.
select * from testdate;

d1
2008-02-29

I tried it in Ansi as well as TD mode.