matt.godsey

Hi, I'm having trouble finding how to change what a null is cast to. In my jrxml file we have: NULL ENDDATE This gets translated to SQL as: cast(NULL as TIMESTAMP) ENDDATE Timestamp is a problem here because ENDDATE is a java.util.date type. In SQL Server, TIMESTAMP is not a date type. Is there a way to control what null is getting cast to, preferably date here. I can't use datetime or datetime2, this needs to be database agnostic. Thanks