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