Subject | Design Help |
---|---|
Author | Robert DiFalco |
Post date | 2003-06-22T18:24:31Z |
If I am using time as milliseconds since epoch and not doing any special
queries with it, is there any advantage to using a TIMESTAMP field over
a NUMERIC(18,0) field? My object stores the value as a long (from
System.currentTimeMillis()) and it seems a bit of a drag to constantly
create Timestamp instances from that long when saving or call .getTime()
on the timestamp object when loading. Thoughts?
Robert
queries with it, is there any advantage to using a TIMESTAMP field over
a NUMERIC(18,0) field? My object stores the value as a long (from
System.currentTimeMillis()) and it seems a bit of a drag to constantly
create Timestamp instances from that long when saving or call .getTime()
on the timestamp object when loading. Thoughts?
Robert