I tried to update a record which has a date field.
Following code works fine when it has a date value.
However, it is not working when that field is null.
<fmtarseDate var="ADOB" value="${param.DOB}" dateStyle='short' />
<sql:transaction>
<sql:update var='updateDemo'>
UPDATE T_PATIENT_DEMO
SET dob= ?
WHERE pid= '${param.PID}'
<sql:dateParam value="${ADOB}" type="date" />
</sql:update>
</sql:transaction>
Following code works fine when it has a date value.
However, it is not working when that field is null.
<fmtarseDate var="ADOB" value="${param.DOB}" dateStyle='short' />
<sql:transaction>
<sql:update var='updateDemo'>
UPDATE T_PATIENT_DEMO
SET dob= ?
WHERE pid= '${param.PID}'
<sql:dateParam value="${ADOB}" type="date" />
</sql:update>
</sql:transaction>