Mapping of Timestamp with Oracle Date datatype
Posted on 2000-04-02
we just have tried to capture the time when user enters the system and this field is stored in the database. here how we do it :
new Timestamp (System.currentTimeMillis ());
this timestamp when we are trying to store in oracle database whose field is of type Date it gives some error as field length is too large.
As timestamp is subclass of date class it should map to date type of oracle datatype.
Kindly help me why is it giving such problems and also is there any way i can store time in milli seconds in oracle database ?