JavaServer Pages, Second Edition

Name

<sql:dateParam>

Synopsis

The <sql:dateParam> action is used as a nested action for <sql:query> and <sql:update> update to supply a date and time value for a value placeholder. If a null value is provided, the value is set to SQL NULL for the placeholder. To ensure portability between different database engines, this action must be used when setting values for DATE, TIME, and TIMESTAMP columns.

The value must be of type java.util.Date or one of the SQL specific subclasses: java.sql.Date, java.sql.Time, or java.sql.Timestamp. If it’s a java.util.Date, the action converts it to the specified subclass.

Syntax

<sql:dateParam value="parameterValue" 
  [type="timestamp|time|date"] />

Attributes

Attributename	Java type	Dynamic valueaccepted	Description
value	java.util.Date	Yes	The parameter value
type	String	Yes	The SQL type the value should be converted to, if needed

Example

<sql:update>
  UPDATE Employee SET EmpDate = ? WHERE EmpId = ?
  <sql:dateParam value="${empDate}" />
  <sql:param value="${empId}" />
</sql:update>