db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Problem with default date values
Date Wed, 08 Aug 2007 21:33:39 GMT
> ALTER TABLE defaultValueTest ALTER COLUMN  dateA WITH DEFAULT 
> DATE('2007-08-09')
> 
> and getting the error: “An attempt was made to get a data value of type 
> 'long' from a data value of type 'DATE'.”

Hi Nathan,

What version of Derby are you working with?

I just tried your statements on the latest trunk code and they
seemed to work fine for me.

I think you need to be using at least version 10.2.2.0 for this to work.

thanks,

bryan


Mime
View raw message