hi

I have some timestamp columns in the database table I'm trying to insert db generated date in those field but I realized that you can only configure one column using timestamp for current timestamp generation ..is there any other way?

More details of the problem :-

<timestamp name="modifiedOnDt" column="MODIFIED_ON_DT" source="db" generated="always" ></timestamp>

<property name="createdOnDt" type="timestamp" generated="never" insert="false" update="false" optimistic-lock="true">
<column name="CREATED_ON_DT" length="10">
<comment>Created By Employee ID</comment>
</column>
</property>


<!--
<property name="modifiedOnDt" type="timestamp" insert="false" update="true" not-null="false" >
<column name="MODIFIED_ON_DT" length="10">
<comment>Last Modified By Employee ID</comment>
</column>
</property>
-->

I'm trying to insert default value in createdondate column and configuring the modifyondate column using timestamp
the logic behind this is that createdondate and modifedondate should be same at insertion and modifedondate should gate update as per the current timestamp values on the consecative updates.. anybody has any solution for this problem