db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Piet Blok" <pbh...@wanadoo.nl>
Subject DATE manipulation
Date Sat, 26 Feb 2005 13:46:15 GMT
Since I am not an expert on databases I am just experimenting a bit in which Derby comes in
very handy.

I am trying to create a table and set a default value for one of the columns that should be
one month from now, like this:
Plan_Date Date NOT NULL DEFAULT CURRENT_DATE + 1 MONTH,

This is not accepted. I got the idea from a site on DB2 (I hoped DB2 and Derby share the same
features) http://www-106.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip3.html

Is there any other way to default to a month from now?

Piet Blok
Mime
View raw message