Hello,

I've been searching and I couldn't find the reason, but why so some people use scale and precision when mapping a datetime field?

example:
<property name="dateModified" type="java.util.Date">
<column name="dateModified" scale="23" precision="3" sql-type="datetime"/>
</property>

Thanks

ok - so I won't answer your question, since I don't know off-hand, but you should use "timestamp" instead, since it is more portable.

I can give you a guess at your question:
scale makes a little sense, since you want to be able to store a large #, that is milliseconds. "precision" doesn't make sense to me at all, and perhaps is a mistake, since it milliseconds will always be an integer, and never a rational-number (in a mathematical sense).